Versions Compared

Old Version 11

changes.mady.by.user Nicolas Rios

Saved on

compared with

New Version 12

changes.mady.by.user Nicolas Rios

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Use SQL Server Enterprise Manager or Management Studio to close any open connections to the SQLcompliance database.
  2. 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.
  3. Use a tool such as IDERA SQL Safe to IDERA 
    Newtablink
    aliasSQL Safe
    urlhttps://www.idera.com/productssolutions/sqlserver/sqlsafebackup
     to restore the SQLcompliance database using the appropriate backup file, including transaction logs.
  4. Use a tool such as IDERA SQL Safe to IDERA 
    Newtablink
    aliasSQL Safe
    urlhttps://www.idera.com/productssolutions/sqlserver/sqlsafebackup
     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.
  5. Use SQL Server Enterprise Manager or Management Studio to bring the SQLcompliance database online.

...