SQL Server Version From Backup File | VirtualSpecies -->

This website uses cookies to ensure you get the best experience. More info...

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 VersionDatabase Version
SQL Server 2017869
SQL Server 2016852
SQL Server 2014782
SQL Server 2012706
SQL Server 2008 R2660/661
SQL Server 2008655

No comments:

Post a Comment