Restore SQL MI Database From BLOB Storage

Описание: Restore SQL MI Database From BLOB Storage

Was receiving an access denied error when trying to restore a database to a SQL Managed Instance.

Msg 3201, Level 16, State 2, Line 3
Cannot open backup device 'https://myblobstorageaccount/dbbackupsfebruary2021/PCSDBHealthAssist_MyDbBackup.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.

All of the Google Searches were wrong.

I needed dot generate a new SAS key on the blob container. Once I did that, I was able to restore the database.

The access denied message was not a SQL Server Error, it was a permission error in the BLB container.

We use our SQL Backup and FTP to backup SQL MI databases to BLOB

https://www.complianceabc.com/sqlback...



Our Web Site https://www.complianceabc.com

FB   / 100063655519542  

X   / pcsromeo  

Linked In   / practical-compliance-solutions