Skip to content

Home

Jump to bottom Edit New page
Randolph West edited this page Dec 20, 2016 · 6 revisions

Remote Storage Sync and Restore

There are two major components to this tool (and two assemblies for each component):

  • Sync - command-line tool that synchronises any SQL Server backup folder with a remote storage location (currently supporting Azure Blob Storage, and UNC paths).

  • Restore - command-line tool that restores a SQL Server database from a remote storage location (currently supporting Azure Blob Storage, and UNC paths), knowing just the database name.

Sync Component

  • AzureBlobStorageSync - command-line tool that synchronises any SQL Server backup folder with Azure Blob Storage.

  • FileStorageSync - command-line tool that synchronises any SQL Server backup folder with a UNC path (e.g. \\SERVER\share).

Restore Component

  • AzureBlobStorageRestore - command-line tool that restores a SQL Server database from Azure Blob Storage, only knowing the database name.

  • FileStorageRestore - command-line tool that restores a SQL Server database from a UNC path (e.g. \\SERVER\share), only knowing the database name.

Important Note

This tool would not be possible without Ola Hallengren's Maintenance Solution, which provides a well-known, strong, naming convention for SQL Server database backup files.

If you do not use Ola's solution, the Sync and Restore tools may not work as advertised.

Copyright (c) Randolph West (BornSQL.ca).

Add a custom sidebar
Clone this wiki locally