Link to home
Start Free TrialLog in
Avatar of Gary Fuqua, CISSP
Gary Fuqua, CISSPFlag for United States of America

asked on

Restoring .bak and .trn files created by an unknown version of Microsoft SQL Server

I have .bak and .trn  backups from an unknown Microsoft SQL Server version.  

Does anyone know if there Is there is a way to tell what version of Microsoft SQL created the files, short of installing every version and testing...
Avatar of Gary Fuqua, CISSP
Gary Fuqua, CISSP
Flag of United States of America image

ASKER

ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Instead of installing all versions and trying to identify. You may try, best possible way using SysTools Backup Recovery. Which not only shows the backup file also repair and recover SQL Server backup file from Corruption. You may try demo version of Free SQl Backup Recovery tool and take test of its feature. And This demo version will show the SQL Server database version. Have a Look: https://www.systoolsgroup.com/sql-backup-recovery/how-it-works.html
Do not agree with best answer