The database server makes a database backup two o'clock in the morning every day and deletes the database backup files 5 days ago, otherwise it will give the hard drive a burst
Information is given in the log in Windows:
DB backup job for SQL Server scheduled job ' DB Maintenance plan ' database maintenance plan 1. ' (0x2da54a5bbefc2b4a874428b91602c52a)-Status: Failed-invoked on:2005-09-09 01:00:00-message: Job failed.
Dispatch 28 (1th Dispatch) wakes up the job called. The last step to run is Step 1th (step 1th).
Logs given in SQL Server:
SQLMaint.exe failed [SQLSTATE 42000]
Related Microsoft-given KB
http://support.microsoft.com/?kbid=288577
http://support.microsoft.com/kb/303292/EN-US/
It seems to speak confused.
Later found that the original database to be backed up, one of which is offline, the result can not be backed up, it can not expire the deletion, no way, had to put it back on the machine.
http://www.bkjia.com/PHPjc/631227.html www.bkjia.com true http://www.bkjia.com/PHPjc/631227.html techarticle Database server daily Two o'clock in the morning for database backup, and 5 days before the database backup files are deleted, otherwise the hard disk to the burst windows of the log to give the letter ...
