All we need is an easy explanation of the problem, so here it is.
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?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
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]
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂