[2004-04-27] Alert! Alert! Alert! Backup and Restore – Baby!
At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments, but I believe at every organization backups are one of the most critical IT functions. Of all backups, database backups, by most accounts, are considered the most critical. I know this is certainly true for me as a SQL Server DBA. I am sure at one point in all of our careers we were too busy to check all of our backups across all SQL Servers, with a million responsibilities on a daily basis. I know some of us were lucky and made it unscathed, while others were not so lucky with backup failures that caused extensive data loss and long downtimes. Now when IT Departments are forced to "do more with less," it is time to put the necessary SQL Server Alerts in place for backup and restore operations in order to more easily monitor and streamline this critical process.