SQL Backup Completes with Success but Backup Failed
I had a RAID controller in a production server fail last night during the backup processing. The job continued to report that each database was backed up successfully but the jobs were failing because the backup files could not be written due to the failed controller. Here is a sample backup email from SQL Backup:
SQL Backup log file
2/7/2006 6:49:19 PM: Backing up RT (full database) to:
2/7/2006 6:49:19 PM: Failed to create backup folder : L:\SQL_BackupsI expect the backup to fail when this occurs.