Unfortunately, dealing with a hard-drive crash and now trying to review and possibly restore the backup files.
So now the question is what version of SQL Server was installed on the crashed server.
Investing using Backup file
Transact SQL – Restore HeaderOnly
from disk ='e:\tmp\DBLAB_backup_2015_08_04_001526_4046147.bak'
- In our case
- Database Version is 661 –> SQL Server 2008
- SoftwareVersionMajor and SoftwareVersionMinor are 10 and 50; and that transpose to MS SQL Server v2008/R2
||Backup up set name
||Backup type ( 1 = Database, 2 = Transaction log, 4 = File, 5 = Differential database, 6 = Differential file, 7 = Partial, 8 = Differential partial )
||Whether the backup set is compressed using software-based compression ( 0 = No, 1 = Yes )
|| User name that performed the backup operation.
|| Name of the server that wrote the backup set.
|| Name of the database that was backed up.
||Version of the database from which the backup was created.
|| 661 ( SQL Server 2008 )
||Date and time the database was created.
|| 2013-10-17 23:02:52.000
||Size of the backup, in bytes.
|| Major version number of the server that created the backup set.
|| Minor version number of the server that created the backup set.
|| Name of the computer that performed the backup operation.
|| 1 = Backup contains backup checksums.
|| 1 = Database was damaged when backed up, but the backup operation was requested to continue despite errors.
|| Byte count of the backup set. For uncompressed backups, this value is the same as BackupSize.To calculate the compression ratio, use CompressedBackupSize and BackupSize.
|| Indicates the containment status of the database ( 0 = database containment is off, 1 = database is in partial containment )
In retrospect, the server crash is causing us to review things that we had an operational blindside to.
As an example, are we using compression, checksum, etc?