Home Forums SQL Server 2008 SQL Server 2008 Administration Access Denied while trying to Delete *.CKP files RE: Access Denied while trying to Delete *.CKP files

  • April 25, 2016 at 3:31 pm

    #1874392

    I have seen this error when two SQL Server are primary log shipping targets and both use the same default backup share. Using Ola Hollengren's backup solution I have all my servers backing up to the same backup share and the backup solution creates subdirectories for each server. So the backups are going to their own directories but because they have the same default backup location they sometimes collide when creating the CKP file.

    For example from server A

    DATE/TIME:4/22/2016 2:30:26 PM

    DESCRIPTION:The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'DeleteFile' on '\\MyShareName\SQLBackupsProduction\RestoreCheckpointDB17.CKP'.

    And on server B

    DATE/TIME:4/22/2016 2:30:25 PM

    DESCRIPTION:The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'DeleteFile' on '\\MyShareName\SQLBackupsProduction\RestoreCheckpointDB17.CKP'.

    If I remember right changing the default backup location to be unique to each server solved the problem