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.
| 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 errorMsg 3104, Level 16, State 1, Line 2RESTORE 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 2RESTORE 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
noamg
Posting Yak Master
215 Posts |
Posted - 2014-02-13 : 04:16:08
|
| I try many time SET PARTNER OFFSET resumeect' ect'nothing help !!!!Noam Graizer |
|
|
|
|
|
|
principal, suspended