Recovery model

In Microsoft SQL Server, configure your recovery model to be either Full or Bulk-Logged.

The following example uses SQL statements to configure the pubs database:

ALTER DATABASE pubs SET RECOVERY FULL

If you need more information on how to perform this task, see your database administrator or refer to your Microsoft SQL Server documentation.