Versions Compared

Key

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

...

Once you back up the archive, you can drop it from the SQL Server instance that hosts the Collection Server. When you need to access older audit data, restore the archive database to the Collection Server, and then attach it using the Management Console. For more information, see Attach existing archives.

When you restore an archive database that was generated by a previous version of SQL compliance manager version, consider updating the database to use optimized indexes. Optimizing indexes enhances performance when working with larger archive databases. For more information, see Update your archive databases.

 

SQL Compliance Manager audits all activity on your server. Learn more > >