RockSolid can be used in to manage database backup and recovery in one of two methods. Either passive management or active management. It is important to note, in either method RockSolid will monitor any and all database backup and recovery actions regardless of:
- If these are initiated by the RockSolid software or another tool
- If these are native SQL Server backup/restore processes or third party tool initiated
- If these were invoked by administrator users or via an application
In passive management your configured policy forms the "objective" of the implemented backup maintenance regardless of method. RockSolid does not deploy any backup processes directly. However RockSolid will monitor whatever backup and recovery processes you are running, regardless of method, to validate if these comply with your requirements specified in RockSolid policy.
If non-compliance is found, events and service requests can be raised.
When under Active Management RockSolid will deploy backup and recovery processes based on your configured policy settings. The combination of calendar schedules and policy requirements for each relevant database will be used to form the backup and recovery plan. RockSolid will then deploy automated backup and recovery jobs based on these policy settings.
If any of these jobs fail or are otherwise unable to execute as per the policy then RockSolid can raise relevant events and service requests. These requests can be escalated to operational resources to resource, or linked to automation processes which can attempt to resolve the issues automatically.