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

How to Install SQL Server 2000

previous page next page
How To

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

previous page start next page