I tried to restore my database from a snapshot. This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 minutes and the spid was in a suspended state. I stopped the query and now my database is stuck in restoring state and my snapshot is unavailable. Am I screwed?
USE master;
RESTORE DATABASE QA from
DATABASE_SNAPSHOT = 'QA_Snap_Testing';
GO
Anonymous User
10-Sep-2015