As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012, you were limited to backing up your databases to a physical device.  That device could be a tape, local disk, or network storage.  After successfully creating a backup, if you’re doing it right, the backups then had to be moved off-site for disaster recovery purposes.

Today, with SQL Server 2012 or higher, you can now backup directly to a URL.  This URL is an endpoint into a cloud storage account, in this case, for Microsoft Azure.  Furthermore, with Azure Availability Zones now available, certain regions give you extra redundancy and will be replicated to another region for a minimal cost.  Not only does this solution offer you the ability to back up your databases off-site, but you get the added benefit of having them replicated for you.

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?