Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 principal, suspended

Author  Topic 

noamg
Posting Yak Master

215 Posts

Posted - 2014-02-12 : 10:42:10
I got my DB into such status.
i try all alter database ....
nothing.
i try to drop the whole DB - but i got error
Msg 3104, Level 16, State 1, Line 2
RESTORE cannot operate on database 'GSMainDB' because it is configured for
database mirroring or has joined an availability group.
If you intend to restore the database, use ALTER DATABASE to remove mirroring
or to remove the database from its availability group.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

I don't know what to do ?


Noam Graizer

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-02-12 : 12:12:01
To remove mirroring on the mirror server, run this: ALTER DATABASE dbNameGoesHere SET PARTNER OFF.

I've had to submit tickets to Microsoft for the suspend status of mirroring. I haven't had any issues with it in SQL Server 2012, but certainly struggled with that status in 2005. We had to add custom alerts to catch this condition, which in my opinion is a bug in the database engine (in our case at least).

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

noamg
Posting Yak Master

215 Posts

Posted - 2014-02-13 : 04:16:08
I try many time
SET PARTNER OFF
SET resume
ect' ect'
nothing help !!!!


Noam Graizer
Go to Top of Page
   

- Advertisement -