Mht1
10 years agoLevel 2
"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