cancel
Showing results for 
Search instead for 
Did you mean: 

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

Mht1
Level 2

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

 

7 REPLIES 7

criley
Moderator
Moderator
Employee Accredited

Markus_Koestler
Moderator
Moderator
   VIP   

What's the actual problem related to SSR 2013? What's the error messag?

TRaj
Level 6
Employee Accredited

We rarely create scripts 

Mht1
Level 2

I'm had a varation on the the problem described below ...

http://www.symantec.com/connect/forums/database-named-rollbacksnapshottempdb-left-after-system-recov...

Its an interaction issue between SSR and MSSQL's VSS service.  The variation in my case was that the I could not use the script identiified in the above link to delete the bogus Rollback DB.  Since I wrote the above post I was able to delete the Rollback with the following steps.

Step 1

ALTER DATABASE "RollbackSnapshotTempDB{xxx}" SET SINGLE_USER WITH ROLLBACK IMMEDIATE

 

Step 2

sp_dbremove "RollbackSnapshotTempDB{xxx}"

 

Is there a Hotfix or patch to correct the creation of the bogu Rollback DBs?

    

criley
Moderator
Moderator
Employee Accredited

What version of SSR are you running (check in Help -- About for specific version details) ?

Mht1
Level 2

SSR 2013  version 11.0.0.46600

also MSSQL 2012 SP1 - version 11.0.3128 (x64)

criley
Moderator
Moderator
Employee Accredited

You need SP2 to get the fix - you don't have that.

If you look at my earlier reply, I did post details of the fix. Here it is again:

http://www.symantec.com/docs/TECH210057