Reverting from a database snapshot when database files on Azure Blob Storage - by Ekrem Önsoy

Status : 

 


3
0
Sign in
to vote
ID 3117785 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 1/2/2017 5:26:08 AM
Access Restriction Public

Description

On a forum post a poster complained about this problem and I could reproduce it on my test environment. When executing the codes pointing a local disk, it works as expected, but when the files are on Azure Blob Storage, it fails.

Mentioned forum post: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3645d385-fc2f-499d-8726-35fdf04365e7/database-revert-from-snapshot-failed-when-i-use-azure-blob-storage?forum=sqldisasterrecovery
Sign in to post a comment.
Posted by Ekrem Önsoy on 1/18/2017 at 11:18 PM
Hello Xiaochen,

Thanks for your interest. I also confirm that this issue does not occur in SQL Server 2016. I had performed the test only in SQL Server 2014 SP2 and the problem is still exist with this version of the product.

I've just performed the test again and it is still reproducable with SQL Server 2014 SP2.
Posted by Microsoft on 1/18/2017 at 8:07 AM
Hi Ekrem,

Thank you very much for the feedback. We will look at this issue. I can't repro this issue in SQL Server 2016. Please give it a try if you want to.

Regards,
Xiaochen