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?
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
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.
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