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 |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2012-01-02 : 14:13:18
|
| I've setup a mirroring for two databases and I wonder, are there any operations I should be aware of on primary SQL Server which won't be transferred to the mirror? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2012-01-03 : 04:28:55
|
quote:
Originally posted by tkizer
No as it requires full recovery model. As long as you don't break the tlog chain, mirroring will do everything. An example: You can break the tlog chain by truncating the tlog. Breaking the tlog chain breaks mirroring, so you would have to start over.
By truncation tlog I hope you mean dbcc log truncating and not taking tlog backups? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2012-01-04 : 09:13:59
|
| To be clear, this will break mirroring:BACKUP LOG [DatabaseName] WITH TRUNCATE_ONLYBut this will not:BACKUP LOG [DatabaseName]Is this correct?Sorry for asking like an idiot, I need to be sure 100%. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-04 : 09:45:15
|
| Backup log with truncate only (which doesn't work on SQL 2008 anyway) or switching to simple recovery will break mirroring. Normal log backups are fine, they can't remove log records that are pending mirroring.--Gail ShawSQL Server MVP |
|
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2012-01-05 : 03:55:10
|
| Thank you tkizer and GilaMonster. |
|
|
|
|
|
|
Non-transferred operations for mirroring