Dangers of Mixing Native Backups and VSS Backups

In today’s modern world of virtualization there are a lot of different ways to backup databases. You’ve got native backups, VSS backups taken by snapshotting the VMs, third party backup tools which take snapshots, etc.

When you have multiple backup techniques all being used at once you run the risk of breaking the LSN chain for your transaction log backups. For your full and differential backups you could end up having a differential backup that you took with one method which is built off of a full backup taken from another backup method. Trying to unwind this during a production down situation becomes very stressful, and depending on the tools which you are using basically impossible to restore from as some tools don’t allow you to restore from them, then restore another layer of backups from another method.

To make life simple and easy to manage only use a single backup method to backup the databases.

Denny

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?

Denny Cherry & Associates Consulting
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.