Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Mirroring & backups of principal databases
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

14 Posts

Posted - 08/17/2010 :  21:15:11  Show Profile  Reply with Quote

I'm trying to understand mirroring better - from what I can see, if a principal database is participating in mirroring, it can have all the normal backups performed on it the same as a non-mirrored database.

But my understanding is that mirroring works through sending tran logs from the principal to the mirrored database, and as such if I did a backup, wouldnt this affect the tran logs, unless the mirroring process uses a separate copy of the tran logs or something similar?

Its confusing...could someone clarify the internal operations of mirroring please and why backups dont affect it please?



Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 08/18/2010 :  01:17:56  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
The mirroring sends the individual log records across, either before the tran is considered committed (synchronous) or shortly after (async). It's not logshipping that sends the tran log backups over.

In the case of synchronous mirroring, since the transaction is not committed until the log records have been sent, the log backup could not remove those records from the log (log backups only remove inactive log entries)
In the case of async mirroring, the log records will be marked as needed for mirroring and the log backup won't be able to remove those log records while they have that mark (much the same as transactional replication and CDC use to ensure that log records they need are not removed)

Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000