Versions Compared

Key

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

...

When identifying the new SQL Server instance that will host the Collection Server, ensure this instance meets or exceeds the product hardware, software, and permissions   requirements, as well as these specific requirements:

  • The target instance is running the same version or higher of the SQL Server software that is currently running on the existing Collection Server computer
  • The current Collection Service account can access the target instance and has the correct permissions on the target instance

Back up the Repository databases

Use a tool such as Idera SQL Safe to IDERA

Newtablink
aliasSQL Safe
urlhttps://www.idera.com/productssolutions/sqlserver/sqlsafebackup
 to perform a full backup of the Repository databases, including transaction logs. You can back up event and archive databases separately from the SQLcompliance databases. However, for best results during a disaster recovery, fully restore all Repository databases at the same time.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 

...

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

...

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