smtzac (12/23/2013)
In my sql instance I have configured log shipping on Prod database and same time there is a Maintenance plan which is taking the same database Full and Diff backups.My question is will Maintenance plan's job (full and diff backups) will break Log shipping job? what happens in case of a disaster should I apply full bak and diff bak files first and then log files (which are taken by log shipping job)?
They would make repairing log shipping a little easier, the differential base LSN is incremented after each full backup doesn't affect the log though.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉