1

I need to set up log-shipping from my SQLPROD2 to server2

but I am facing the following problems:

1) I already use ola hallegren backup solution, and it provides the 15 min log backups for all databases - can I use this job instead of the job the log shipping wants me to use?

or alternatively should I remove the databases that I add to the log shipping from the Ola's user database backup job?

2) what about the full backups that I take once a day? would that mess up the log shipping? should I do a full backup with copy_only?

enter image description here

1

If you are using Ola's solution, its intelligent to exclude log shipping dbs. See FAQs

Does the SQL Server Maintenance Solution support log shipping?

The SQL Server Maintenance Solution supports log shipping. Full and differential backup, integrity check, and index and statistics maintenance are performed on the primary database. Transaction log backups are not performed on databases that are involved in log shipping.

.

what about the full backups that I take once a day? would that mess up the log shipping? should I do a full backup with copy_only?

A full backup wont break log backup chain. Only an additional NON COPY_ONLY log backup will break the log chain.

If you have folks taking adhoc log backups, you can DENY BACKUP LOG to [user|group]

  • +1 for always being around and pointing out at the documentation, thank you Kin – Marcello Miorelli Dec 13 '18 at 1:04

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.