O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required