Backup file Version in MSSQL Server [Resolved]

Posted by Yrajudba under Sql Server on 9/20/2011 | Points: 10 | Views : 2968 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

I have a backup file with extension .bak.
I want to check, the existing backup file belongs to 2005 or 2008. i need to restore at client place.
Is there any query to find out the version of the backup file.

Thanks in Advance!!!
Raju

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Yrajudba on: 9/20/2011 [Member] Starter | Points: 25

0	HI Pandian Thanks a lot for your help!!! Thanks & Regards, Raju Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: PandianS on: 9/20/2011 [Member] [MVP] Silver | Points: 25

0	Hi Raju Yes. You can find out the information from the Valid Backup File (.Bak) Use Master Go Restore headeronly from disk='<Backup file Path.Bak>' Go Check the columns from the above statement SoftwareVersionMajor , SoftwareVersionMinor , SoftwareVersionBuild I hope it would help :) Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Raju

Yes. You can find out the information from the Valid Backup File (.Bak)

Use Master

Go

Restore headeronly from disk='<Backup file Path.Bak>'

Go

Check the columns from the above statement SoftwareVersionMajor , SoftwareVersionMinor , SoftwareVersionBuild

I hope it would help :)

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts