Do Full Backups Break Log Shipping?

TLDR: Nope.

A tub boat pushing logs down a river
Image by jakeforlove from Pixabay

Keep on doing your full backups.

Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs, etc.

The Backup Chain will not be broken by running a Full backup, and you do not need to use Copy-Only

Proof:

Thanks for reading!

Kevin3NF

Leave a Comment

Sign up for our Newsletter

%d bloggers like this: