SQL Server Performance

How do find the database version from .bak file

Discussion in 'SQL Server 2005 General DBA Questions' started by AJITH123, Jun 9, 2008.

  1. AJITH123 Member

    Hi,
    I have a SQL '.bak' file, but i dont know which SQL server version it is? Can any way to find the version with out installing the same?
    Thanks
    Ajith
  2. MohammedU New Member

    You can use RESTORE HEADERONLY command...
    RESTORE HEADERONLY
    FROM DISK = N'C:AdventureWorks-FullBackup.bak'


Share This Page