Large DB backup stumper

Question

Large DB backup stumper

RandyB

SSCommitted

Points: 1565
More actions
June 16, 2005 at 6:52 am

#110556

I have a 65GB database with 2 filegroups, each one containing 1 file. When I try to do a full backup, whether thru a maintenance plan or not, I get the following error:
BackupMedium::ReportIoError: write failure on backup device 'K:\MSSQL7\BACKUP\mbs\MBS_db_200506152300.BAK'. Operating system error 33(The process cannot access the file because another process has locked a portion of the file.).
The backup job runs for 4 or 5 hours then dies with the above error. I rebuilt the database recently due to table structure changes but I had the problem with the old db also. The very first backup I did on this new database worked but now subsequent ones will not.
I am not getting any specific help from MS KB.
Has anyone else seen this?
Is there some service that runs on Win2K that is known to cause this problem?
My other backups on various dbs < 10GB work fine.
Thanks for any help.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

DCPeterson SSCoach Points: 15266 More actions · Answer 1

If I recall correctly we had a similar issue that was caused by our netbackup system. We wound up scheduling the SQL backups and the NetBackup so that the SQL backups completed before Netbackup started and we never saw that issue again.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 2

I'd agree 100% with this, we had the exact same problem and resolved it by rescheduling the second backup to a time after the first one had finished

RandyB SSCommitted Points: 1565 More actions · Answer 3

I rescheduled the backups to run this weekend well after the system backups are finished.

Thanks for the suggestions.

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 4

Watch out for Virus scanners as well, DB, log, trace, etc. files should always be excluded.

Andy

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 5

But who in their right mind wouldn't have already excluded all of these things from the virus scanners

Quick appologies to anyone willing to admit it

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 6

I agree for SQL Server, but now that every tom dick an harry app is installing MSDE...

Andy

Ken Klaft-191610 SSC Veteran Points: 270 More actions · Answer 7

Mike

I'll only admit I ran into the error before .

Definitely either scheduled backups and virus scanning [will] cause this error. Depending on the scanning package, you may have trouble writing to the 'locked' file again after the error.

RandyB SSCommitted Points: 1565 More actions · Answer 8

Wow.

I don't know much about virus scanners. Our Network Admin installs them and handles firewall issues.

We are running eTrust on that server.

Is there any whitepaper or kb article that explains this so I have some ammo to take to them?

Thanks.

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 9

SQL Server Security: Dealing with Anti-Virus Programs

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

This is the best that I have seen.

Andy