Thursday, December 26, 2013

MSSQL Server recovery models

This mentions there are three kinds of recovery models:

  1. Simple
  2. Full
  3. Bulk logged

 
 

This mentions how to change the setting. Something taken verbatim from there is:

  1. After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
  2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
  3. Right-click the database, and then click Properties, which opens the Database Properties dialog box.
  4. In the Select a page pane, click Options.
  5. The current recovery model is displayed in the Recovery model list box.
  6. Optionally, to change the recovery model select a different model list. The choices are Full, Bulk-logged, or Simple.
  7. Click OK.

No comments:

Post a Comment