Is there any way to cancel redo logs in mirror server ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Is there any way to cancel redo logs in...

Is there any way to cancel redo logs in mirror server ?

Rate Topic

Display Mode

Topic Options

Author

Message

Joy Smith San

Posted Saturday, September 22, 2012 1:43 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,371, Visits: 2,302

Hello,

Safety = FULL. No witness.
Principal goes down, and there's a long redo queue in mirror and will take long time to be up.
Suppose I am not worried about those logs but I just need to bring the mirror server up.
Is there any way to cancel those redo logs in mirror ? Data loss is acceptable.

Thanks,
San.

Post #1363166

GilaMonster

Posted Saturday, September 22, 2012 2:04 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:03 AM
Points: 37,734, Visits: 30,004

No, it's the same as crash recovery when starting up a DB. Without there are logged changes that do not reflect in the data file, ie the database would be inconsistent without them

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1363167

Joy Smith San

Posted Sunday, September 23, 2012 12:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,371, Visits: 2,302

.. So ultimately I need to wait till it recovers. And time left to recover will be available in Mirror error log is it ?
By the way, a FORCE failover won't help here as well ?

Thanks Gila.

Post #1363196

GilaMonster

Posted Sunday, September 23, 2012 3:49 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:03 AM
Points: 37,734, Visits: 30,004

Should be.

Forcing a failover won't help, because this is not the failover process, it's the bringing of the DB online after the failover.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1363210

Joy Smith San

Posted Sunday, September 23, 2012 4:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,371, Visits: 2,302

Thanks a lot Gila.

Post #1363211

Arjen Krap

Posted Monday, September 24, 2012 9:47 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, April 07, 2013 1:20 PM
Points: 51, Visits: 161

Do I understand correctly, the same delay will happen when failing over when using clustering or log shipping?

Post #1363768

« Prev Topic | Next Topic »

Permissions