Комментарии:
How did you now what value to use for teh URL that you backed up to and restored from?
What version of SSMS are you suing? I can't get mine, version 18.X, to connect to Azure but I can do it with Azure Data Studio so I know my credentials are good and the connection info is right.
I'm using SSMS 2019 and i get this error "Statement 'RESTORE DATABASE' is not supported in this version of SQL Server."
ОтветитьNice, Jovan one quick question. Do you know if I can restore a database in simple recovery mode from on-premise to Azure MI? I know Azure MI will not support database in simple recovery mode. But will the restoration work? If so, will it convert the database to full recovery mode?
ОтветитьCan you explain how to see / navigate dead locks in managed instances
ОтветитьMsg 3201, Level 16, State 2, Line 4 all the time...Microsoft have made this a hell.
ОтветитьHow about restore from Managed Instance to SQLVM?
ОтветитьI got message 'Operating system error 86(The specified network password is not correct)'. I've created SAS Token, can't understand the reason.
ОтветитьOne of our engineer accidentally deleted Test SQL managed instance on Azure.
Is there any way we can recover databases that were created on that instance?
Recovery service vault wasn't configured as it was a test instance.
Can you suggest what do with Databases having multiple log files? as Managed Instance does not support multiple log files
ОтветитьWhen running the restore command an error occurs:
Msg 40510, Level 16, State 1, Line 48
Statement 'RESTORE DATABASE' is not supported in this version of SQL Server.
We have created the master key and credential and confirmed they exist.
Is there a different syntax for restore database for Azure SQL Managed Instance?
Thank you for posting this video.