May 18, 2022 at 5:07 pm
A client of ours is upgrading their database to SQL Server 2019.
The edition of the SQL server that these database backups are currently being automatically restored to is SQL Server 2016. I was wondering if anyone knew if its possible to restore a 2019 backups to a 2016 server without changing the compatibility level before its sent (also assuming the backup isnt compressed)?
I don't have a 2019 server in my environment to test this with currently so thought I'd hit up you fine gentlemen.
May 18, 2022 at 5:11 pm
You cannot restore a 2019 database to a 2016 server even if you're in the 2016 compatibility mode on the 2019 server.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 18, 2022 at 6:46 pm
Thank you sir I appreciate it.
May 18, 2022 at 8:19 pm
In fact, you cannot restore any newer-version SQL Server db to any older-version SQL instance, period. Just does not work.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
May 24, 2022 at 10:10 pm
Well....there's always a way. The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server. It's not nearly as nice a process as the backup restore process you probably already have automated, but it is possible.
May 25, 2022 at 2:54 am
Well....there's always a way. The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server. It's not nearly as nice a process as the backup restore process you probably already have automated, but it is possible.
I've never tried that and haven't had the need to do so but thanks for the tip. I didn't know such a thing would work.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply