Home > Backend Development > PHP Tutorial > SQL Server automatic backup cannot delete expired backup files_PHP tutorial

SQL Server automatic backup cannot delete expired backup files_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-13 17:00:43
Original
1325 people have browsed it

The database server performs database backup at two o'clock in the morning every day, and at the same time deletes the database backup file from 5 days ago, otherwise the hard disk will burst
The information in the windows log is:
SQL Server Scheduled Job 'DB backup job for DB maintenance plan "Database Maintenance Plan 1". ' (0x2DA54A5BBEFC2B4A874428B91602C52A) - Status: Failed - Invoked on: 2005-09-09 01:00:00 - Message: Job failed.
Schedule 28 (Schedule 1) wakes up the job. The last step to run is step 1 (step 1).
The log given in sql server:
sqlmaint.exe failed [SQLSTATE 42000]
Relevant kb given by Microsoft
http://support.microsoft.com/?kbid=288577
http://support.microsoft.com/kb/303292/EN-US/
It seems that the explanation is confusing.
Later I discovered that one of the original databases to be backed up was offline. As a result, it could not be backed up, nor could it be deleted when it expired. I had no choice but to put it back on my computer.


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631227.htmlTechArticleThe database server performs database backup at two o'clock in the morning every day, and at the same time deletes the database backup file 5 days ago, otherwise A message will appear in the Windows log that explodes the hard disk...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
sql file
From 1970-01-01 08:00:00
0
0
0
php - Overhead of prepare vs sql?
From 1970-01-01 08:00:00
0
0
0
Print sql statement
From 1970-01-01 08:00:00
0
0
0
Pass array to SQL insert query using PHP
From 1970-01-01 08:00:00
0
0
0
sql optimization or
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template