SQL server backup issue - locked file

389 Views Asked by At

We have standart maintenance BACKUP plan

Task of backup has verifyonly option enabled.

During perfroming of backup we have failed job because VERIFYONLY task failed because of backup file was holded by another process. If I grub code from maintenance plan for any specific db(backup operation + restore verifyonly ) and run it manualy from query window this also failing with same error. If I add delay in two minutes between backup and restore verifyonly then i get no errors. This looks like something locking backup file right after creation and does not allow to run verifyonly. I have downloaded Process Monitor and tried to check activity for backup file , there is nothing except System , sqlserver.exe , and explorer.exe processes that touching the file.Did someone faced with this issue previously ?

0

There are 0 best solutions below