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 |
|
JJSQLDBA
Starting Member
23 Posts |
 Posted - 2012-09-30 : 21:26:42
|
| Hi All,I would like to clear this doubt about logshipping and backup policy.When you have logshipping set up for a database, is it possible to apply a normal backuppolicy on top of it. If we can't, why it is not possible? if we can what are the things we have to make surebefore we do it or what are the extrasteps you have to take?any inputs are appreciated and thank you in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-09-30 : 21:31:47
|
| You can do full and diff backups outside of the log shipping plan, but you can not do tlog backups outside of the plan. Just use the log shipping backups though.The reason why you can't do tlog backups outside of the plan is that they form a chain, and that entire chain must be restored to the secondary server in the proper order. If one file is missed, it breaks log shipping. So if you ever have to do a one-off tlog backup, make sure you manually apply it to the secondary server with norecovery in order not to break log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Loshipping and Backup