Azure SQL Database - Matt Mansoomi (Page 2)

Matt Mansoomi

Azure SQL Database

All issues related to Azure SQL Database and Managed instance. I am trying to explain how to solve the common issue like connectivity issue or anything related to backup, failed over and other functionality.

Grant SQL managed identity to Storage Blob Data Contributor role

Grant SQL managed identity to Storage Blob Data Contributor role

In some scenarios like this you need to grant SQL managed identity Storage Blob Data Contributor role on the Storage account, for doing this you need to create the storage account first, then from the left blade choose “Access Control (IAM)” and “Add role assignment” like the below screenshot. From

Restore Managed Instance database with Power Shell

Restore Managed Instance database with Power Shell

This week I got customer for somehow needed to restore the Managed Instance database with Power Shell, He asked the help as they got issue with restoring database with Power Shell, it seemed every time they got different error messages with new command, the errors were like: Restore-AzSqlInstanceDatabase: Cannot bind

Not able to restore SQL Database with PITR?

Not able to restore SQL Database with PITR?

Last week when I tried to restore the SQL database with PITR I got the following error message in Azure Portal. { "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID: