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
