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

Is there any way to cancel redo logs in mirror server ? Expand / Collapse
Author
Message
Posted Saturday, September 22, 2012 1:43 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 1,606, Visits: 2,671
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
Posted Saturday, September 22, 2012 2:04 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 40,662, Visits: 37,127
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
Posted Sunday, September 23, 2012 12:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 1,606, Visits: 2,671
.. 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
Posted Sunday, September 23, 2012 3:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 40,662, Visits: 37,127
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
Posted Sunday, September 23, 2012 4:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 1,606, Visits: 2,671
Thanks a lot Gila.
Post #1363211
Posted Monday, September 24, 2012 9:47 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 1, 2014 2:36 AM
Points: 51, Visits: 199
Do I understand correctly, the same delay will happen when failing over when using clustering or log shipping?
Post #1363768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse