Zookeeper
SQL Server online consultantsCame guest SS an interesting scenario where one of our client was unable to restore a native SQL Server backup successfully saved from one instance running on Machine A on another instance of SQL Server running on machine B.
If you try to restore the same backup on same instance on the machine, restore completes successfully without any issues but it always fails when you try to restore the database from same backup file on any other instance on a different host.
Use SQL:
RESTORELOG dbNameFROMDISK = 'd: \ Hot backup \ dbName. trn' WITHFILE = 2, NORECOVERY
The restore always fails with the below message:
The restore fails with the message similar
"The media family on device 'C: \ Program Files \ Microsoft SQL Server \ MSSQL \ BACKUP \ myDB. trn' is incorrectly formed. SQL Server cannot process this media family ".
Please try to remove'FILE = 2,'It can work on my side.