Versions Compared

Key

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

The Recovery Model tab of the Configure Repository Databases window allows you to select which database recovery model you want the Collection Server to configure when creating databases to store audit data in the Repository. You can choose either the simple model or the default model. The Collection Server applies this setting to new event databases created for each audited SQL Server instance and new archive databases.

Image Added

A database recovery model controls whether transaction logs are backed up for each database. The simple model does not allow you to back up transaction logs for a database. The default model does allow you to back up transaction logs for a database. The default model is the recovery model configured for the model database. Typically, when a database is created, SQL Server applies the model database properties to the new database. The model database properties on the SQL Server that hosts the Repository should reflect your overall backup and disaster recovery strategies. Before choosing the default recovery model setting, verify that the model database properties are correct.

...

You can change your selection at any time. When you select a different database recovery model, your change affects new databases only. Ensure you manually change the database recovery model used on each existing Repository database.

Image RemovedImage Added

Scroll pdf ignore
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.
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

...