Posts tagged SQL

MSSQL Recovery Models

Mar 18th

Posted by PB in Database

No comments


Background

Each SQL Server database includes the Recovery Model property, which determines how transactions are logged, whether the transaction log can be backed up, and the type of restore operations permitted. By default, a new database inherits the recovery model from the model database. However, you can override the default setting by assigning a different recovery model.

Choices

You can configure a SQL Server database with any one of the following three recovery models.

More >

, ,

How to identify your SQL Server version and edition

Feb 12th

Posted by PB in Database

No comments

To determine which version of Microsoft SQL Server 200, 2005 or 2008 is running, connect to SQL Server by using SQL Server Management Studio and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Note

For SQL Server 2000 connect to SQL Server 2000 by using Query Analyzer.

The following results are returned:

* The product version (for example, 10.0.1600.22)
* The product level (for example, RTM)
* The edition (for example, Enterprise)

For example, the results resemble the following.
10.0.1600.22 RTM Enterprise Edition
More >