Forum Discussion
Solved
Database Needed across versions
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.
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
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.
