0

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

Improve this question

1 Answer 1

Reset to default
4

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.