Thursday, January 20, 2011

How do you find SQL Server Backup File Version?

When you have a different backup files form various SQL Servers. How do you find a version of  SQL Server backup ? ( SQL Server 2008, 2005, 2000)

Restore Headeronly from disk='E:\backup\MyDb.bak'

SoftwareVersionMajor
10  for SQL Server 2008
9    for SQL Server 2005

8    for SQL Server 2000



 

No comments: