This mentions there are three kinds of recovery models:
- Simple
- Full
- Bulk logged
This mentions how to change the setting. Something taken verbatim from there is:
- After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
- Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
- Right-click the database, and then click Properties, which opens the Database Properties dialog box.
- In the Select a page pane, click Options.
- The current recovery model is displayed in the Recovery model list box.
- Optionally, to change the recovery model select a different model list. The choices are Full, Bulk-logged, or Simple.
- Click OK.
No comments:
Post a Comment