Cannot Drop Snapshot Which Doesn’t Exist

Here was an interesting problem we ran into recently.  We use SQL Server database snapshots to help load our data warehouse.  To do this, we have an automated process which drops and re-creates snapshots as needed.  Not too long ago, we started running into a problem in which the process failed to run, giving me…

Advertisement