How To Identify Version of SQL Server from Backup File


Today, one of my colleague asked me that  how can we find the sql version from backup file? then i thought this article is also help for many other people then i decide to share this article through my Post.

Through below query we can find out the version:-


RESTORE HEADERONLY
FROM DISK = N'D:\Backup\SampleDb.bak' ---Give the backup file path


You can find the output like below format:-

 

 

 

 

  • After that you have to find  your Database Version in below list — (In My case it was 661 –means SQL Server 2008R2)

 

 

 


 

Leave a Reply

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