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 |
|
dcunningham
Starting Member
25 Posts |
 Posted - 2008-04-09 : 12:18:53
|
| Hello,I have an SQL 2005 maintenance plan that backups up the t-logs of my production db every 15 minutes. I want to begin log shipping over to a warm-standby secondary server. The network share, log shipping folder is not the same folder location as my maintenance plan folder. My question is, do I need to disable the maintenance plan for tlog backups in order for log shipping to be sucessful? Or will the dual backups to seperate backup folder locations cause a failure in the secondary server restore process?I suspect the latter but wanted a second opinion.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 12:25:48
|
| Yes you need to disable the maintenance plan for Log backup for log shipping to work. Log shipping will do T-log backup according to the schedule you set. |
 |
|
|
dcunningham
Starting Member
25 Posts |
Posted - 2008-04-09 : 12:28:13
|
| Thank you for that confirmation, I beleive so as well. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-09 : 12:34:11
|
| It has nothing to do with it being in a separate backup folder. If you run tlog backups outside of the log shipping plan and you don't manually apply them to the warm standby, then you will break log shipping. This concept has to do with restoring transaction log backups and not necessarily about log shipping. You must restore tlogs in the order in which they were backed up and you can't skip any. Log shipping uses tlog backups, so the concept applies.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dcunningham
Starting Member
25 Posts |
Posted - 2008-04-09 : 14:11:01
|
| Thanks for your reply Tara. Yes, I believe that was the implication, that some logs would be in two different locations and that the log shipping restore job on the secondary server would unabale to apply those logs because of missing LSNs. Those missing LSN's would be located in the TLog backups generated by the maint plan.Regards. |
|
|
|
|
|
|
TLog backup then start Log Shipping