[TroubleShooting]'trn\bak' is incorrectly formed. SQL Server cannot process this media family.
SQL Server online consultants came across an interesting scenario where one of our client was unable to restore a native SQL Server backup successfully performed 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 A, 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:
RESTORE LOG dbName FROM DISK = ‘D:\Hot backup\dbName.trn‘ WITH FILE = 2, NORECOVERY
The restore always fails with the below message:
The restore fails with the message similar to
“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.
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
