1

I m confused with backup for log shipping,by taking full backup(not copy- only) in primary ,does it affect the log backup LSN chain and cause log shipping not to work? If it does not affect LSN chain, can i take full backup and differential backup in primary and then for log backup can i use log backup which is done by log shipping in shared folder for restoration incase primary and secondary server down.

0

By taking full backup(not copy- only) in primary ,does it affect the log backup LSN chain and cause log shipping not to work?

No..Never. Full backup has NO affect on transaction log backup chain it is not going to break the logshipping. I strongly suggest you to read Backup Myths section by Paul Randal.

can i take full backup and differential backup in primary and then for log backup can i use log backup which is done by log shipping in shared folder for restoration in case primary and secondary server down.

Yes you can, neither full nor diff backup would break log shipping, although your request seems strange to me. If their is LS database and you want to restore full, diff and log backup make sure you do not let log backups be deleted from shared drive after the threshold is crossed in LS.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.