Forum Discussion

Mht1's avatar
Mht1
Level 2
10 years ago

"RollbackSnapshotTempDB" in Single User Mode - can't delete

I have a  "RollbackSnapshotTempDB" is single user mode on a system with SQL2012 and SSR2013.  I have tried the following with no luck.  Any help would be appreciated

Step 1:

USE master

GO

ALTER DATABASE "RollbackSnapshotTempDB{XXX}"

SET OFFLINE WITH ROLLBACK IMMEDIATE

GO

Step 2:

DROP DATABASE "RollbackSnapshotTempDB{XXX}"

Step 3:

ALTER DATABASE DISTRIBUTION

SET MULTI_USER;

GO