table.hovertable {
\nfont-family: verdana,arial,sans-serif;
\nfont-size:11px;
\ncolor:#333333;
\nborder-width: 1px;
\nborder-color: #999999;
\nborder-collapse: collapse;
\n}
\ntable.hovertable th {
\nbackground-color:#c3dde0;
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}
\ntable.hovertable tr {
\nbackground-color:#d4e3e5;
\n}
\ntable.hovertable td {
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}<\/p>\n
How to Identify SQL Server Database Backup Version.<\/strong><\/p>\n Following is the query: Specify the correct path of the backup file.<\/p>\n When this query is executed read the values of the columns SoftwareVersionMajor,SoftwareVersionMinor and SoftwareVersionBuild<\/strong>.<\/p>\n The version of the SQL Server backup can be found by concatinating the values in three columns. If the output is Then the version of database backup is 10.50.2500<\/p>\n SoftwareVersionMajor also gives an idea of the major version of SQL Server.
\n[sql]
\nRESTORE HEADERONLY FROM DISK=’C:DatabaseBackupsDatabaseBackup.bak’
\n[\/sql]<\/p>\n
\nversion of backup = SoftwareVersionMajor.SoftwareVersionMinor.SoftwareVersionBuild<\/p>\n
\nSoftwareVersionMajor = 10
\nSoftwareVersionMinor = 50
\nSoftwareVersionBuild = 2500<\/p>\n
\nIt helps to determine if the database backup is of SQL Server 2005 or SQL Server 2008.<\/p>\n