Backup job failed with below error:
Msg 3202, Level 16, State 2, Line 1
Write on "H:\Backups\XXXX\XXX_FULL_20110926.BAK" failed: 33(The process cannot access the file because another process has locked a portion of the file.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Write on "H:\Backups\XXXX\XXX_FULL_20110926.BAK" failed: 33(The process cannot access the file because another process has locked a portion of the file.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Resolution:
As per below image, check the Disk properties for ‘Compress drive to save disk space’ is checked or not.
If yes, please uncheck and execute the backup query, it will execute successfully.
Simultaneous running of both process (backup and drive compress process) cause the backup failure.
No comments:
Post a Comment