Versions Compared

Old Version 2

changes.mady.by.user Unknown User (6092bc7c442457007123ca0f)

Saved on

compared with

New Version Current

changes.mady.by.user Nicolas Rios

Saved on

Key

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

To ensure optimal audit performance while minimizing storage requirements, consider implementing a maintenance plan to backup back up your archive databases on a routine basis using IDERA SQL Compliance Manager. Each archive database is independent, and you can be maintained maintain each on a different schedule.

Once you back up the archive, you can drop it the archive 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 the database using the Management Console. For more information about attaching archives, see Attach existing archives.

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



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 | 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse