Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

After breaking mirror, the mirrored database is in restoring state Expand / Collapse
Author
Message
Posted Wednesday, January 2, 2008 10:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 20, 2012 10:05 AM
Points: 8, Visits: 38
Hi,

I mirrored one database in high protection mode. When I break the mirror by click Stop Mirroring within the the database Properties, Mirroring page for the principal database, I got a message on the mirror server read "The database 'xyz' is marked RESTORING and is in a state that does not allow recovery to be run."

Later on, I managed to restore the tail log from the principal database to bring the "mirrored" database on line.

Anything did I do wrong?

Thanks,

-Yuemo

Post #438063
Posted Thursday, January 3, 2008 7:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:58 AM
Points: 2,280, Visits: 3,069
Why did you choose to stop Mirroring? Were you trying to backup the Mirrored database?

When you stop mirroring, the databases can get out of sync. The only way to bring the databases to a consistent state is to restore from the latest backups of the principal server, which you did with the transaction log backups.





My blog: http://jahaines.blogspot.com
Post #438378
Posted Friday, January 4, 2008 4:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 20, 2012 10:05 AM
Points: 8, Visits: 38
Well, we were trying disaster recovery test to simulate one server down.

So if the principal is down, how to make mirror into production?

Thanks,

-Yuemo
Post #439154
Posted Saturday, January 5, 2008 6:24 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
[font="Verdana"]In high protection or high performance mode if the principal server is down then your mirror db will be in restoring state. Now inorder to make the mirror db as principal you need to connect to the mirror server and type the following command to perform manual failover,

Alter database mirrordbname set partner force_service_allow_data_loss

that will bring the mirror db online and you can work on it !
hope this helps


- Deepak
Post #439231
Posted Monday, January 7, 2008 10:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 20, 2012 10:05 AM
Points: 8, Visits: 38
Thanks, that makes sense!

I re-read the section of mirroring. I missed that part.

Our application is not suitable to failover automatically. This is why I did not add the witness, as I though we have to break the mirror manually anyway.

It looks like having a witness will be better.

Thanks again!

-Yuemo
Post #439709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse