troubleshooting Question

Db backup issues

Avatar of sharscho
sharscho asked on
Microsoft SQL Server
4 Comments1 Solution352 ViewsLast Modified:
Hi Experts, I am having backup issues with a user db for 3 days in a row now. The error I get from the sqlserver error log is the following (In this order):

BackupMedium::ReportIoError: write failure on backup device 'D:\SqlServer_Backups\Palb_db_200807202000.BAK'. Operating system error 33(The process cannot access the file because another process has locked a portion of the file.).

Internal I/O request 0x36685D18: Op: Write, pBuffer: 0x0D220000, Size: 983040, Position: 44046096896, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x415A1A00, OffsetHigh: 0xA, m_buf: 0x0D220000, m_len: 983040, m_actualBytes: 0, m_errcode: 33, BackupFile: D:\SqlServer_Backups\Palb_db_200807202000.BAK

BACKUP failed to complete the command BACKUP DATABASE [Palb] TO  DISK = N'D:\SqlServer_Backups\Palb_db_200807202000.BAK' WITH  INIT ,  NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMATThe size of this db is 75G. I want to know how to get the other process that is using a portion of the file to prevent it from being backed up for 3 days. Has someone experience with similair error issues.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros