Is Managed instance db backup to URL could be restored on local SQL 2017?

Question

Is Managed instance db backup to URL could be restored on local SQL 2017?

ebooklub

Hall of Fame

Points: 3905
More actions
November 28, 2018 at 1:39 pm

#382372

I Thought that it would be possible to create my own managed instance db copy save it to URL and restore from URL on my local 2017 DEV server ...
BACKUP DATABASE [Customers] TO URL = N'https://myexternal.blob.core.windows.net/disasterrecoverybackup/Customers.bak' WITH COPY_ONLY,
INIT, NAME = N'Full Database Backup', NOREWIND, NOUNLOAD, FORMAT,MAXTRANSFERSIZE = 4194304, COMPRESSION, STATS = 10
backup worked fine
But restore on local 2017 server failed
RESTORE DATABASE [Customers] FROM URL = ''https://myexternal.blob.core.windows.net/disasterrecoverybackup/Customers.bak'
Msg 3169, Level 16, State 1, Line 7
The database was backed up on a server running version 15.00.1000. That version is incompatible with this server, which is running version 14.00.1000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.
What cofused me ...
when running on azure managed instance
select @@version
you get
Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 2 2018 21:17:06 Copyright (C) 2018 Microsoft Corporation

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

ebooklub - Wednesday, November 28, 2018 1:39 PM
I Thought that it would be possible to create my own managed instance db copy save it to URL and restore from URL on my local 2017 DEV server ...
BACKUP DATABASE [Customers] TO URL = N'https://myexternal.blob.core.windows.net/disasterrecoverybackup/Customers.bak' WITH COPY_ONLY,
INIT, NAME = N'Full Database Backup', NOREWIND, NOUNLOAD, FORMAT,MAXTRANSFERSIZE = 4194304, COMPRESSION, STATS = 10
backup worked fine
But restore on local 2017 server failed
RESTORE DATABASE [Customers] FROM URL = ''https://myexternal.blob.core.windows.net/disasterrecoverybackup/Customers.bak'
Msg 3169, Level 16, State 1, Line 7
The database was backed up on a server running version 15.00.1000. That version is incompatible with this server, which is running version 14.00.1000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.
What cofused me ...
when running on azure managed instance
select @@version
you get
Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 2 2018 21:17:06 Copyright (C) 2018 Microsoft Corporation

That's a known issue about the @@version and Azure. Azure will be at the same level or ahead of the latest on-premise version. Read the note in the middle of this documentation which explains the issue:
@@Version - Transact SQL Configuration Functions

Sue