大家好,又见面了,我是全栈君,今天给大家准备了Idea注册码。
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.
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/116685.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...