{"id":117,"date":"2012-01-12T04:50:36","date_gmt":"2012-01-12T04:50:36","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/01\/12\/identify-sql-server-database-backup-version\/"},"modified":"2012-01-12T04:50:36","modified_gmt":"2012-01-12T04:50:36","slug":"identify-sql-server-database-backup-version","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/01\/12\/identify-sql-server-database-backup-version\/","title":{"rendered":"Identify SQL Server Database Backup Version"},"content":{"rendered":"

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:
\n[sql]
\nRESTORE HEADERONLY FROM DISK=’C:DatabaseBackupsDatabaseBackup.bak’
\n[\/sql]<\/p>\n

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.
\nversion of backup = SoftwareVersionMajor.SoftwareVersionMinor.SoftwareVersionBuild<\/p>\n

If the output is
\nSoftwareVersionMajor = 10
\nSoftwareVersionMinor = 50
\nSoftwareVersionBuild = 2500<\/p>\n

Then the version of database backup is 10.50.2500<\/p>\n

SoftwareVersionMajor also gives an idea of the major version of SQL Server.
\nIt helps to determine if the database backup is of SQL Server 2005 or SQL Server 2008.<\/p>\n\n\n\n\n\n\n
Identify Database Backup Version<\/th>\n<\/tr>\n
SoftwareVersionMajor = 9<\/td>\nbackup is of SQL Server 2005<\/td>\n<\/tr>\n
SoftwareVersionMajor = 8<\/td>\nbackup is of SQL Server 2000<\/td>\n<\/tr>\n
SoftwareVersionMajor = 10 and SoftwareVersionMinor = 0<\/td>\nbackup is of SQL Server 2008<\/td>\n<\/tr>\n
SoftwareVersionMajor = 10 and SoftwareVersionMinor = 50<\/td>\nbackup is of SQL Server 2008 R2<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

Related posts:
\nVerify SQL Server Database Backup<\/a>
\nrestore higher version database backup on lower version sql server \u2013 restore problem<\/a>
\nThe media family on device is incorrectly formed. SQL Server cannot process this media family Error: 3241<\/a>
<\/p>\n","protected":false},"excerpt":{"rendered":"

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:…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[137,41,3],"tags":[732,733,734,735,736,737,738,739,740,741,742,743],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-databasebackup","category-sql-server-basics","category-sqlserverpedia-syndication","tag-backup-file-is-file-is-sql-server-2005-or-2008","tag-database-backup-version","tag-find-find-database-backup-version","tag-how-to-find-database-backup-version","tag-how-to-identify-sql-server-database-backup-version","tag-restore-headeronly","tag-restore-headeronly-from-disk","tag-softwareversionbuild","tag-softwareversionmajor","tag-softwareversionmajor-softwareversionminor-softwareversionbuild","tag-softwareversionminor","tag-version-of-the-sql-server-backup"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}