Recovering SQL Server data

Published: December 16, 2009

Applies To: Forefront Client Security

If you have had a failure of one of the MOM collection or reporting databases (OnePoint or SystemCenterReporting) or the SQL Server reporting database (ReportServer), follow the procedures in this section to recover the database. If you are recovering from a failure of your collection or reporting servers, reinstall the appropriate server components before restoring the database.

By default, the MOM and SQL Server reporting databases use the Simple Recovery model. Because of this, you will not be able to restore these databases to the point of failure. For each database that you are restoring, you should restore the most recent full database backup, and then restore any differential database backups.

For more information about restoring databases, see Backing Up and Restoring Databases in SQL Server in SQL Server Books Online (http://go.microsoft.com/fwlink/?LinkId=75174).

To restore the collection (or OnePoint) database

  1. Restore the most recent full database backup.

  2. Restore any available differential database backups.

  3. Recover the database.

  4. Grant db_owner access for the Data Access Server (DAS) account to the OnePoint database.

To restore the reporting (ReportServer or SystemCenterReporting) databases

  1. Restore the most recent full database backup.

  2. Restore any available differential database backups.

  3. Recover the database.

Related Topics

 
Show: