Recovering to the point of failure

Published: December 16, 2009

Applies To: Forefront Client Security

By default, Client Security databases use the Simple Recovery model. It is not possible to use Simple Recovery to recover a database to the point of failure. If you have set one or more of your databases to use the Full Recovery model, then you can recover to the point of failure if you have the appropriate transaction log backups.

To recover your database to the point of failure, you must be able to back up the currently active transaction log. If you cannot do so due to media failure or other problems, you have to recover the database to an earlier point in time.

The basic steps for recovering a database to the point of failure are listed in the following procedure. For more information about recovering a database to the point of failure, see Performing a Complete Database Restore (Full Recovery Model) in SQL Server 2005 Books Online (http://go.microsoft.com/fwlink/?LinkId=75175).

To recover to the point of failure

  1. Back up the currently active transaction log.

  2. Restore your backups of the Master and MSDB databases.

  3. Restore the most recent full database backup.

  4. Restore any differential database backups that were created after the most recent full backup.

  5. Restore transaction log backups up to and including the log you backed up in step 1.

  6. Recover the database.

Related Topics

 
Show: