SOLVED

Database Needed across versions

Copper Contributor

I have a database that I need to be able to use on versions 2016 - 2022.  My machine currently has SQL 2019.

 

I have kept the database at the SQL 2014 (120) compatibility level since I don't need any features beyond that level. 

 

If I back the database up on SQL 2019, will I still be able to restore it to the 2016 servers?  I personally don't have a 2016 server configured, so I'm hoping to be able to skip setting one up, just to do the backups.  

 

Thanks.

2 Replies
best response confirmed by alwweb (Copper Contributor)
Solution

@alwweb 

 

You can only restore a database running the same version or higher than the one you took the back-up from.

 

This means you cannot take a back-up from SQL Server 2019 and restore it to SQL Server 2016.

 

Cheers,

Lain

Thank you! I thought that was the case, but I was hoping I was wrong.
1 best response

Accepted Solutions
best response confirmed by alwweb (Copper Contributor)
Solution

@alwweb 

 

You can only restore a database running the same version or higher than the one you took the back-up from.

 

This means you cannot take a back-up from SQL Server 2019 and restore it to SQL Server 2016.

 

Cheers,

Lain

View solution in original post