How to set the recovery model for a database (Enterprise Manager)

How to set the recovery model for a database (Enterprise Manager)

To set the recovery model for a database

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, right-click the database, and then click Properties.
   
   
3. Click the Options tab.
   
   
4. In the Model list, click a recovery model.

See Also

Using Recovery Models