Recovery Models and Logging
Each database is configured with a particular SQL Server recovery model that determines the manner in which transaction logging and SQL Server recovery are handled. When you create a database, the recovery model for that database is set to the recovery model of the system model database. If you do not change the model database recovery model setting after SQL Server installation, then all user databases are created with the Full recovery model setting, the default of the model database. The recovery model can be changed using the Management Studio or T-SQL commands.
The following sections describe the three possible recovery models: simple, full, and bulk-logged. For all three recovery models, data backups must be taken ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
