Recovering SQL Server data
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 (https://go.microsoft.com/fwlink/?LinkId=75174).
To restore the collection (or OnePoint) database
Restore the most recent full database backup.
Restore any available differential database backups.
Recover the database.
Grant db_owner access for the Data Access Server (DAS) account to the OnePoint database.
To restore the reporting (ReportServer or SystemCenterReporting) databases
Restore the most recent full database backup.
Restore any available differential database backups.
Recover the database.