[TroubleShooting]'trn\bak' is incorrectly formed. SQL Server cannot process this media family.
来源:互联网 发布:数控外圆磨床编程教程 编辑:程序博客网 时间:2024/06/04 19:55
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:
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 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.
- [TroubleShooting]'trn\bak' is incorrectly formed. SQL Server cannot process this media family.
- foreign key constraint is incorrectly formed
- The ENU localization is not supported by this SQL Server media
- 《Troubleshooting SQL Server》读书笔记
- SQL SERVER导入BAK文件
- Troubleshooting deadlock in SQL Server
- [SQL SERVER][TroubleShooting] sa登入密碼忘記
- VS2010 + Sql Server Express 2008 R2 如何安装(兼谈错误:The database 'XXX' cannot be opened because it is version 661. This server support
- 用SQL Server 2000还原.bak文件
- SQL Server 2005导入bak文件
- SQL Server 2008导入bak文件
- SQL Server 2005导入bak文件
- SQl Server利用bak文件还原数据库
- 还原sql server 数据库(.bak文件)
- 使用bak文件还原SQL Server
- sql server 还原备份的bak文件
- SQL Server 2005导入bak文件
- Andriod XML Editor cannot process this input
- 游戏学习路线_读书笔记
- HTML5的页面资源预加载技术(Link prefetch)加速页面加载
- 你可能没听过的 Java 8 中的 10 个特性
- e'rjfpwe wef
- IOS笔记
- [TroubleShooting]'trn\bak' is incorrectly formed. SQL Server cannot process this media family.
- jQuery.extend 函数详解
- 【SVN】设置中文路径权限
- web.xml 中的listener、 filter、servlet 加载顺序及其详解
- 进程操作
- IBM 公司最新的出差安全守则
- SQL SERVER存储过程批量插入数据库…
- 给自己一个健康的生活作息表,让自己的生活不再没有规律
- oracle批量插入数据的方法1