Database backup plan on a mirrored scenario

Question

Hi, I am   designing the database maintenance plan, for a SQL Server 2008 R2 using Database Mirroring (Two SQL Servers), I need to know if the database backup design I made is acceptable, it is based on this article http://msdn.microsoft.com/en-us/library/ms181092(v=sql.105).aspx The plan would be: t0 Full Backup t1 Transaction Log Backup t2 Shrink Log t3 Differential Backup t4 Transaction Log Backup t5 Shrink Log t6 Differential Backup .. (Starts again) Questions: 1) Is it necessary to make a Diff Backup when using Transaction Log Backup? 2) Does this plan conflicts in any way with database mirroring? (not in the case of a role switch, I mean, under normal operation of the mirror) Many Thanks

Answer 1

Why shrink the log file?

>>>>1) Is it necessary to make a Diff Backup when using Transaction Log Backup?

No

>>2) Does this plan conflicts in any way with database mirroring? (not in the case of a role switch, I mean, under normal operation of the mirror)

No

We usually do FULL /LOG file backup on the primary database....

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing