SQL Server Automatic Backup cannot delete outdated backup files _php tutorial

Source: Internet
Author: User
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 ...

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.