Versions Compared

Key

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

Maintaining the Repository databases helps you achieve optimal performance and ensure long-term audit data integrity. Repository database maintenance includes backup and restore operations, and should coincide with your established disaster recovery strategies.

Before you implement a disaster recovery strategy for the Repository databases, review the following supported recovery model settings.

Repository DatabaseSupported Recovery Model
SQLcomplianceRecovery model set for the model system database
SQLcompliance.ProcessingSimple
SQLcompliance_InstanceSimple, or recovery model set for the model system database
SQLcmArchive_
Instance
instance_Time_PartitionSimple, or recovery model set for the model system database

You can perform backups on a routine basis as a scheduled job or manually on an as-needed basis. Refer to your established disaster recovery strategies when implementing a backup or restore policy for the Repository databases. Tools such as Idera SQLsafe allow IDERA 

Newtablink
aliasSQL Safe
urlhttps://www.idera.com/productssolutions/sqlserver/sqlsafebackup
 allow you to schedule fast, secure backups using optimized compression and encryption settings.



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