How to know Database Version or Build no from a Backup File?

Generally we don’t need this info for user database but when you have to recover or restore master database then you should have exact database version or build no else you cannot recover your database like i am giving you a scenario suppose you instance is corrupted now you are not able to access your sql server instance and even you don’t have exact database version like 9.00. ****. In this case you need exact build no else you cannot recover your sql server Instance. To get this info you need a master database backup file. You can run below cmd to get this info:

Restore headeronly from disk=’D:MSSQLBackupmaster.bak’

Now output will show you lot much info like user name,LSNs,device type,server name etc but you should look into below three columns  to get exact version no of SQL Server. As per this output the version on which master database was backed up is 10.50.1600.Now you got the exact build so install sql server till this build no and restore master database easily.

SoftwareVersionMajor  SoftwareVersionMinor  SoftwareVersionBuild
10                                  50                                   1600

If you like this tip, you can follow us on our facebook page and on Twitter handle to get latest updates.

Read More:

 

Follow me:

Manvendra Deo Singh

I am working as a Technical Architect in one of the top IT consulting firm. I have expertise on all versions of SQL Server since SQL Server 2000. I have lead multiple SQL Server projects like consolidation, upgrades, migrations, HA & DR. I love to share my knowledge. You can contact me on my social accounts for any consulting work.
Manvendra Deo Singh
Follow me:

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *