unrestored log?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » unrestored log?

unrestored log?

Rate Topic

Display Mode

Topic Options

Author

Message

ananda.murugesan

Posted Monday, September 17, 2012 12:14 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:56 AM
Points: 817, Visits: 2,395

Hi,

Principal server mirroring monitor history logs (intervel time every 3 min)

Unsent Log 7588 KB
unrestored log 600 KB
Mirror over head - 40 Milliseconds

Next intervel time those are 0 kb, 0 millseconds,
Does it means everything restored at mirror database?

Post #1359984

Perry Whittle

Posted Monday, September 17, 2012 1:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 5,201, Visits: 11,151

ananda.murugesan (9/17/2012)

What does the mirroring status tell you on each occasion for the principal and mirror?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1360002

ananda.murugesan

Posted Monday, September 17, 2012 1:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:56 AM
Points: 817, Visits: 2,395

What does the mirroring status tell you on each occasion for the principal and mirror?

Every occasion for the principal & mirror server status is sychcronized mode.

Post #1360005

GilaMonster

Posted Monday, September 17, 2012 5:20 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:12 AM
Points: 37,665, Visits: 29,917

The unrestored log is the portion of the log at the mirror server that has not yet been replayed against the mirror database. Everything's been send across (it is synchronised mirroring), the replay is just very slightly behind. At 600k, I wouldn't worry, that shouldn't take more than a few seconds to replay if/when a failover occurs.

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 #1360114

ananda.murugesan

Posted Monday, September 17, 2012 5:30 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:56 AM
Points: 817, Visits: 2,395

ok, SQL agent side mirror logs jobs running every 3 minites, I understod the next time intervel history logs display those were 0KB, 0 milliseconds, so everything restored at mirror database at next time sychronized . I don't want worry about it.

Post #1360118

« Prev Topic | Next Topic »

Permissions