SETTING: Backup History Retention (Instance)

This setting controls how much backup history is retained on the SQL Server instance after the data has been collected by the RockSolid monitoring processes.

In general, as history information is centralised into the RockSolid repository off the SQL Server instance it is good practice to keep the amount of history data retained on the instance to a minimum.  This ensures that the maximum amount of space is available to user databases rather than being consumed by system historical data.

If you enable this option you must also specify the number of days backup history to retain.  RockSolid will automatically purge any backup history data older than this number of days from the MSDB database.  This purge will occur on an ongoing basis as part of the monitoring process.

This setting does not affect the amount of data retained within the RockSolid repository.  To change the amount of data store in RockSolid you can configure this here.

Example: Retaining 30 days of SQL Server backup history on the instance.

Have more questions? Submit a request


Please sign in to leave a comment.