Backup on Maintenance Plan Fails

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Backup on Maintenance Plan Fails

Author

Topic

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2012-05-09 : 23:25:13

We have 2000 Version SQL Server on which there is a maintenance plan working for full backup. It works fine during the Weekdays and on Friday well in the late hours of evening it fails altogether. The simple reason being disk space insufficient, which should be fine for the weekdays but suspiciously fails and we miss the very relevant backup till monday.

There is no such SQL job running during the weekend times;

Disk Space is very much intact and adequate;

Neither there exists any error being loaded on the Errorlog file or the maintenance plan result text signifies as follows:

2012-05-05 22:24:46.07 backup BACKUP failed to complete the command BACKUP DATABASE [DIMA] TO DISK = N'E:\Backup\DIMA\DIMA_db_201205052200.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

2012-05-06 22:24:57.73 spid62 BackupMedium::ReportIoError: write failure on backup device 'E:\Backup\DIMA\DIMA_db_201205062200.BAK'. Operating system error 112(error not found).
2012-05-06 22:24:57.73 spid62 Internal I/O request 0x7F0C1D58: Op: Write, pBuffer: 0x0A420000, Size: 983040, Position: 83563321856, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x74C31A00, OffsetHigh: 0x13, m_buf: 0x0A420000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: E:\Backup\DIMA\DIMA_db_201205062200.BAK
2012-05-06 22:24:57.73 backup BACKUP failed to complete the command BACKUP DATABASE [DIMA] TO DISK = N'E:\Backup\DIMA\DIMA_db_201205062200.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Can anyone suggest what would be the mystery of weekend failure as to where I should begin my inquiry.

Thanks All

Sachin.Nand

2937 Posts

Posted - 2012-05-11 : 13:31:59

Did you try creating a job that takes a backup and schedule it at the same time when your maintenance plan runs ?

After Monday and Tuesday even the calendar says W T F ....

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2012-05-13 : 18:36:32

Yes. The maintenance plan runs which picks up the backup.

Thanks for your Time.

Only on FRIDAY Evening the 'Maintenance Clean Up Task' Fails to remove the old backup from its place as it does other weekdays.

This Friday I have 'Manually' deleted the old backup and then everything is fine thereafter.

What I could not see is there is no evidence either from the Text of the maintenance plan history / Errorlog.

How should I monitor and find the bottleneck on this particular day (Friday Evening) as a I claimed there is no other process which runs or any job is intervening or do any intruder clinging on to the Server.

Any other clue Please. many thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources