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)