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.