RESTORE HEADERONLY FROM DISK = <path to backup file>

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

            FileStream f = new FileStream("C:\\SQLData\\MyBackupFile.bak", FileMode.Open);
            byte[] b = new byte[2];
            f.Seek(3756, SeekOrigin.Begin);
            b[0] = (byte)f.ReadByte();
            b[1] = (byte)f.ReadByte();
            Int16 dbVersion = BitConverter.ToInt16(b, 0);
            f.Close();

Add-Type -TypeDefinition @"
using System;
using System.IO;
public class GetSQLBackup
{
    public static int getDbVersion(string backupFilePath)
    {
        FileStream f = new FileStream(backupFilePath, FileMode.Open);
        byte[] b = new byte[2];
        f.Seek(3756, SeekOrigin.Begin);
        b[0] = (byte)f.ReadByte();
        b[1] = (byte)f.ReadByte();
        Int16 dbVersion = BitConverter.ToInt16(b, 0);
        f.Close();
        return dbVersion;
    }
}

"@