SQL Server Version From Backup File

We can easily find out the database version by checking the important server details of the backup files using the below script.

1
2
USE msdb
RESTORE HEADERONLY FROM DISK = 'C:\MicrosoftSQLServer\MSSQL\Backup\DatabaseBackup.bak'

Run the script and look for DatabaseVersion.

Here is the list of the SQL Server and Database versions.

SQL Server Version	Database Version
SQL Server 2017	869
SQL Server 2016	852
SQL Server 2014	782
SQL Server 2012	706
SQL Server 2008 R2	660/661
SQL Server 2008	655