sparse file gets deleted from management studio but not from disk

  • In one of our DR environments application team has created a job which drops old snapshot and creates snapshot daily, but one day application team contacted us saying that the snapshot job is failing on server, when we checked from our end it was failing with the error snapshot file already exists in the specified location.

    In simple terms snapshot got deleted from management studio but not from disk, what could be the possible reasons for this to happen ?

    Couldn't find any errors within SQL error logs and from event viewer as well.

    Thanks in Advance.

  • Was the snapshot online when they dropped it?

    What's the exact command(s) they used?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply