Our freshly provisioned Azure SQL managed instance fails restoring backups from URL.
According to the server log the restore itself seems to finish after a certain amount of time but errors in following processes lead to a termination of the whole process...
The error message prompted by SSMS is
Msg 22003, Level 16, State 1, Line 7
Stale/aborted version cleanup was aborted for database id '5' due to database shutdown.
Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.
The relevant part of the server log can be found here.
I tried backup files from different SQL Server versions (2012, 2016, 2019) -- even the backup of an empty database causes this error...
Did anybody experience something similar? Google does not seem to help at all.
The command used is:
RESTORE DATABASE Test FROM URL = N'https://STORAGEACCOUNT.blob.core.windows.net/STORAGECONTAINER/Test.bak'
The necessary credential got created via:
CREATE CREDENTIAL [https://STORAGEACCOUNT.blob.core.windows.net/STORAGECONTAINER] WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 'sv=xxxxxxxxxxxxxxxxxxxxxx';
STORAGECONTAINER as well as most of the