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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.