Page History
...
- Use SQL Server Enterprise Manager or Management Studio to close any open connections to the SQLcompliance database.
- Use SQL Server Enterprise Manager or Management Studio to take the SQLcompliance database offline. If you cannot take the SQLcompliance database offline, stop the Collection Service.
- Use a tool such as IDERA
to restore the SQLcompliance database using the appropriate backup file, including transaction logs.Newtablink alias SQL Safe url https://www.idera.com/productssolutions/sqlserver/sqlsafebackup - Use a tool such as IDERA
to restore each event database using the appropriate backup file, including the transaction logs. Each registered SQL Server instance has a corresponding event database. For more information, see Product components and architecture.Newtablink alias SQL Safe url https://www.idera.com/productssolutions/sqlserver/sqlsafebackup - Use SQL Server Enterprise Manager or Management Studio to bring the SQLcompliance database online.
...