Posts tagged MSSQL
SQL Server 2005 Features Comparison
Mar 23rd
![]()
The main features are
The tables below present details about each of the different SQL 2005 editions.
MSSQL Recovery Models
Mar 18th
![]()
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.