Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlguy7777
Starting Member
14 Posts |
 Posted - 2010-08-17 : 21:16:49
|
| HowdyI'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?CheersSG |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 04:47:09
|
| it will definitely affect the mirroring process if you took a full backup. you need to reset so succeeding trans log restore on the receiving server will not failin mirroring, it's one full backup on the source server, restored to norecovery on the receiving server and the rest are trans logs backup and restore with norecoveryif you want a full backup, do a backup database with copy_only or mirror to option...--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-18 : 05:23:08
|
| please do not cross post. You now have two people answering the same question in two threads which just wastes peoples time.Any replies in the other thread please: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148923 |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-18 : 05:23:28
|
quote:
Originally posted by jen
it will definitely affect the mirroring process if you took a full backup. you need to reset so succeeding trans log restore on the receiving server will not fail
Why would log restores fail if a full backup is taken?quote:
in mirroring, it's one full backup on the source server, restored to norecovery on the receiving server and the rest are trans logs backup and restore with norecovery
That's log shipping. Mirroring doesn't use log backups.--Gail ShawSQL Server MVP |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 06:37:17
|
| my bad, got confused with the statement about trans logs--------------------keeping it simple... |
|
|
|
|
|
|
Mirroring & database backups - how?