•
14 min read
Monitoring SQL Server Backups
One of the most important tasks for the** **DBAs is to ensure that there is a maintenance plan to recover data from a given disaster. Â As a DBA we need to design a maintenance plan according to our scenario and business requirements. Do we want to be able to recover data at any point of time? How much data loss can we accept? All these questions and many more must be answered before designing the plan. In this post we will assume a basic daily full backup to keep our data safe, we will assume that there is a job performing full backups to our databases every day at midnight.