Remote Storage Sync and Restore

18 months ago, I released a free tool to the SQL Server community, called Azure Blob Storage Sync and Restore, to help ease the pain in a disaster recovery scenario.

I'm pleased to announce today a major update to the tool, which includes support for network UNC paths, as well as Azure Blob Storage, for synchronising and restoring your SQL Server backup files. All versions of SQL Server from 2005 to 2016 are supported.

Irrespective of the version of SQL Server you use today, you can copy your backups to a UNC path, and/or Azure Blob Storage, without changing any settings on your database instance.

The companion restore utility will let you restore the very latest backup of a database from a UNC path, knowing only the database name. It includes differential and transaction log backups if they are available, and supports point-in-time restores of that database as well.

Aside from disaster recovery scenarios, the restore tool is very useful for testing backups, as it always fetches the most recent backup.

Please take a look at BornSQL.ca to find out more about this tool. You can even dive right into the GitHub source code repository.

The Remote Storage Sync and Restore tool is written in C#, and is released under the MIT License. It relies on the strong naming convention provided by Ola Hallengren's Maintenance Solution.

The tool is completely free for commercial and non-commercial use, provided you include a copyright notice.

For more information, please contact Randolph West.