SQL Server 2016 introduces a new type of SQL Server backup for database files stored in Microsoft Azure blob storage. This new type of backup is called File-Snapshot backup and it leverages the storage snapshot capabilities of Azure blob storage to take nearly instantaneous backups and perform incredibly fast restores.
In this demo, you will see the performance difference when restoring to a point in time using traditional streaming backups versus using file-snapshot backups.
- SQL Server product team blog at https://blogs.technet.com/b/dataplatforminsider/
- SQL Server Data Files in Windows Azure https://msdn.microsoft.com/en-us/library/dn385720.aspx
- File-Snapshot Backups for Database Files in Azure https://msdn.microsoft.com/en-us/library/mt169363.aspx
- Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases https://msdn.microsoft.com/en-us/library/dn466438.aspx