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.
| Author |
Topic |
|
jennyjen
Starting Member
4 Posts |
 Posted - 2007-02-12 : 11:46:28
|
| Hi Everyone,About 2 months ago i have noticed that my sql database backup has been failing with the following error:BACKUP failed to complete the command BACKUP DATABASE [databasename] TO DISK = N'D:\server\MANDRAKE\MANDRAKE_db_200702080015.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT A couple of times the backup would run when maunally started but no longer does that. It also fails with the above error.Any help would be great,thanks,jen |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-12 : 11:57:29
|
| Either the line above or below this line in the errorlog will give an operating system error. What is that error? |
 |
|
|
jennyjen
Starting Member
4 Posts |
Posted - 2007-02-12 : 12:07:52
|
| maybe this is what you are looking for?BackupMedium::ReportIoError: write failure on backup device 'D:\server\MANDRAKE\MANDRAKE_db_200702120015.BAK'. Operating system error 33(The process cannot access the file because another process has locked a portion of the file.let me know what you think,thanks,jen |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-12 : 12:32:32
|
| One of two things that usually happen with this error are either the filesystem backup is coinciding with the database backup, or the virus scan software is holding on to the file. I would start with the filesystem backup. |
|
|
|
jennyjen
Starting Member
4 Posts |
Posted - 2007-02-12 : 13:24:52
|
| i dont know anything about SQL..could you point me in a direction?Thanks,thanks,jen |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-12 : 14:21:08
|
| Check to see what time the files are backed up on that server. If the time that the files are being backed up are close to the timestamp of your error, you just need to adjust the timing of the SQL backup to take place before the backup of the files. |
|
|
|
jennyjen
Starting Member
4 Posts |
Posted - 2007-02-13 : 11:12:34
|
So i moved my backup to 3 hours later than it is normally schedualed to run. The backup still failed with the same error. Again this morning i tried to manually start the SQL database backup (while no other backup or antivirus was running) and it still failed after about 1 hour of running. Any ideas on what to do next?quote:
Originally posted by mcrowley
Check to see what time the files are backed up on that server. If the time that the files are being backed up are close to the timestamp of your error, you just need to adjust the timing of the SQL backup to take place before the backup of the files.
thanks,jen |
|
|
|
|
|
|
|
|
Database Backup Failing