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';
I removed STORAGECACCOUNT
and STORAGECONTAINER
as well as most of the SECRET
.
Best Answer
When using a managed service, I expect that getting past errors like these ones is outside of your control:
In this case, the "system administrator" you need to contact is Microsoft. I'd recommend that you reach out to them via support channels.