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.
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.
Loshipping and Backup
Posted - 09/30/2012 : 21:26:42
