Can we use multiple backup software programs at the same time?

All we need is an easy explanation of the problem, so here it is.

We’ve implemented EMC NetWorker (Legato) as a network based SQL Server backup solution. Previously we used SQL Server Backup via Ola Hallengren’s scripts. Can we continue to do both or will that mess up the backup/restore chain?

Thanks
Gord

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.

Method 1

Regarding the backup/restore chain being messed, yes, it might be messed if you try to take log backups on both backup tools, for example. See Requirements for restoring transaction log backups. But if you would choose take a full backup using the copy only option in one of the tools, it would not mess the recovery chain.

Also, every backup you take have an impact on the server. It costs resources to generate the backups, so if you keep 2 different solutions, you might cause your server to suffer resource contention for a longer period increasing the maintenance window.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply