Help required on DB Mirroring - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

Help required on DB Mirroring

Author

Topic

richieasir
Starting Member

13 Posts

Posted - 2010-07-06 : 06:44:57

Hello There

while trying to failover from mirror server i am getting the below error message

"Msg 1417, Level 16, State 1, Line 1
Database mirroring has been disabled by the administrator for database "FIFA".

What we have done is:
1) We have manually stoped the server where Principal database was there.
2) Then we try to manually failover from morror server by executing the below command.

alter database fifa set partner force_service_allow_data_loss

then we got the status of mirror database as "Inrecovery"
--> Please tell us what is Inrecovery mode

Then we manually started the Principal and executed the below command from mirror.

alter database fifa set partner force_service_allow_data_loss

But while executing this command, we are getting the below error:

"Msg 1417, Level 16, State 1, Line 1
Database mirroring has been disabled by the administrator for database "FIFA".

--> Also the status of Principal and mirror now is:
Principal: Principal/Suspended
Mirror: Principal/synchronized

Please suggest how to bring mirroring back

Thank you
Richards

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-07-06 : 10:31:34

In recovery means that the database is waiting for further transaction logs from the mirroring session or from a restore operation. If you simply want to bring it online just issue a "RESTORE DATABASE dbname WITH RECOVERY".

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources