Existing Snapshots can not be accessed or deleted after SQL 14 upgrade. - by MSSales Dev

Status : 


Sign in
to vote
ID 811464 Comments
Status Active Workarounds
Type Bug Repros 4
Opened 12/12/2013 3:10:44 PM
Access Restriction Public


Existing Snapshots on a SQL Server are not accessible after an upgrade to SQL Server 2014. The snapshots can neither be deleted. The following is the error msg that is thrown when trying to access or delete the snapshots. 

Msg 946, Level 14, State 1, Line 1
Cannot open database 'Domains' version 706. Upgrade the database to the latest version.
Sign in to post a comment.
Posted by Eric2000 on 3/24/2015 at 6:06 AM
Thanks Ottsca, that did it for me.
Posted by Ottsca on 8/8/2014 at 10:30 PM
Here was my work around. Stop SQL Server Service. Delete the .SS file. Start the SQL Server Service. Delete the snapshot. Create the snapshot. My process also involved a couple of Availability Group failovers so that things stayed up and running through this work around.
Posted by RichardPhoebix on 5/4/2014 at 11:30 AM
Hi Ajay,

if this is expected behaviour, and I cannot delete the snapshot, am I to leave the snapshot there forever? Doesn't seem sensible.
Posted by xor88 on 4/12/2014 at 9:29 AM
The snapshots cannot be dropped. Please confirm this to be a bug and that it will be fixed.
Posted by Ajay [MSFT] on 12/16/2013 at 12:35 PM
Thanks for reporting this. This is expected behavior, and database snapshots are not expected to be work after an upgrade.

Ajay Jagannathan
Senior Program Manager