table.hovertable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
table.hovertable th {
background-color:#c3dde0;
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
table.hovertable tr {
background-color:#d4e3e5;
}
table.hovertable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
How to Identify SQL Server Database Backup Version.
Following is the query:
[sql]
RESTORE HEADERONLY FROM DISK=’C:DatabaseBackupsDatabaseBackup.bak’
[/sql]
Specify the correct path of the backup file.
When this query is executed read the values of the columns SoftwareVersionMajor,SoftwareVersionMinor and SoftwareVersionBuild.
The version of the SQL Server backup can be found by concatinating the values in three columns.
version of backup = SoftwareVersionMajor.SoftwareVersionMinor.SoftwareVersionBuild
If the output is
SoftwareVersionMajor = 10
SoftwareVersionMinor = 50
SoftwareVersionBuild = 2500
Then the version of database backup is 10.50.2500
SoftwareVersionMajor also gives an idea of the major version of SQL Server.
It helps to determine if the database backup is of SQL Server 2005 or SQL Server 2008.
Identify Database Backup Version | |
---|---|
SoftwareVersionMajor = 9 | backup is of SQL Server 2005 |
SoftwareVersionMajor = 8 | backup is of SQL Server 2000 |
SoftwareVersionMajor = 10 and SoftwareVersionMinor = 0 | backup is of SQL Server 2008 |
SoftwareVersionMajor = 10 and SoftwareVersionMinor = 50 | backup is of SQL Server 2008 R2 |
Related posts:
Verify SQL Server Database Backup
restore higher version database backup on lower version sql server – restore problem
The media family on device is incorrectly formed. SQL Server cannot process this media family Error: 3241
great valuable information…………Thank lot