Post image

AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage

SQL Server 2016, released last month, now lets us back up our database files to two locations simultaneously. This is very good news if we’re running the latest and greatest (and it really is a good upgrade). For everyone else, the bad news is that we are targeting an on-site destination for our backups (local network,
-> Continue reading AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage

Post image

The Resilience of the Log Backup Chain

Much has been written about the log backup chain in SQL Server, where we are able to restore a database to a point in time using a combination of full, differential and transaction log backups. This requires a database being in Full Recovery Mode and transaction log backups being taken at regular intervals. If the database is
-> Continue reading The Resilience of the Log Backup Chain

Post image

Update to Azure Blob Storage Sync and Restore

Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I made several improvements, and fixed an outstanding bug. As you know, it relies on the naming convention provided in Ola Hallengren’s Maintenance Solution and comes in two parts: the AzureBlobStorageSync command-line application, and
-> Continue reading Update to Azure Blob Storage Sync and Restore

Post image

Pre-Announcement Announcement

On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from Azure Blob Storage”. I will be releasing some new content and code at the same time as my talk, which will be available from this site, assuming WordPress plays along.
-> Continue reading Pre-Announcement Announcement