还原出错：the backup set holds a backup of a database other than the existing，

最新推荐文章于 2020-05-07 12:41:36 发布
最新推荐文章于 2020-05-07 12:41:36 发布
阅读量441 收藏
点赞数
文章标签： 数据库 运维
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fytcm/article/details/84127369
版权
mssql server 2005还原出错：the backup set holds a backup of a database other than the existing，error:3154

特别是，导入外面的数据时，可能mdf或ldf的路径与本机的不一样，导致用界面操作无法导入。此时建议用命令导入： 


restore database Test
from disk = 'C:\share\20120111TestDB.bak'
with replace,
move 'Test' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf',
move 'Test_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test_log.ldf'

fytcm
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
DB - Paxos Replicated State Machines as the Basis of a High
07-10
semantics weaker than sequential consistency, a limited update interface (such as append-only), primary-backup replication schemes that serialize all reads through the primary, clock synchronization ...
The development of intelligent behavior III: Robert W. White
06-29
The development of intelligent behavior III: Robert W. White THE DEVELOPMENT OF INTELLIGENT BEHAVIOR 111: ROBERT W. WHITE THOMAS ROWLAND AND CARSON MCGUIRE The University of Texas at Austin ...
SQL SERVER 2005恢复数据错误解决：The backup set holds a backup of a database other than the existing 'XXX' da...
12-23 204
在sqlServer20005 的management studio里使用bak文件还原数据库的时候,总是失败! Restore failed for Server 'ADANDELI'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or bat...
The backup set holds a backup of a database other than the existing ‘dbName’ database
weixin_30421809的博客
10-22 111
 [Solved] System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database http://blog.csdn.net/j2eevic/article/details/7408432 --返回...
【原创】The backup set holds a backup of a database other than the existing 'DBTest' database.
weixin_30813225的博客
08-13 1024
恢复Sql Server 2000到Sql Server 2008时出现错误：The backup set holds a backup of a database other than the existing 'DBTest' database. 网上有教程是这样说的： 1、在数据库中新建一个数据库，如DBTest 2、将sql server 2005的兼容级别设置为...
[TroubleShootin]The backup set holds a backup of a database other than the existing 'xxdb' database.
码农, 农民工的程序人生
04-25 2069
One: he backup set holds a backup of a database other than the existing ‘xxdb’ database Sometime when you try to restore the backup file on an existing database and receive the followi
SQL SERVER 2008恢复数据错误解决：The backup set holds a backup of a database other than the existing
热门推荐
VIC Hakuna Matata
03-29 1万+
今天从新加坡现场环境生成了一个数据库备份的文件发过来，我们两边用的都是Microsoft SQL Server 2008 R2， 在sqlServer20008 的management studio里使用bak文件还原数据库的时候,总是失败! 报"The backup set holds a backup of a database other than the existing ..."错。
js按住鼠标左键选中元素框代码.zip_JS holds_The Element_mouse
09-15
在JavaScript编程中，"js按住鼠标左键选中元素框代码"涉及到的是与用户交互、事件处理以及DOM操作相关的知识点。在这个场景中，我们通常需要监听鼠标的按下和移动事件，来实现用户按住鼠标左键时选择元素的效果。...
psr.rar_The Fields
09-21
This file holds the macros for masking off various parts of the processor status register on the Sparc. This is valid for Version 8. On the V9 this is renamed to the PSTATE register and its members ...
test-decls.rar_The Right Track
09-23
A DeclarationContext holds a reference to a v8::Context and keeps track of various declaration related counters to make it easier to track if global declarations in the presence of interceptors behave...
还原数据库：The backup set holds a backup of a database other than the existing database
DuceXu的专栏
11-02 1万+
查了好长时间资料才搞定这个问题。 使用SQL Server Management Studio的向导方式为新建的DB执行From Device Restore时，出现错误讯息：“The backup set holds a backup of a database other than the existing database”，使用以下方法解决： 1、删除新建的DB 2、直接右键Data
备份集保存除现有数据库以外的数据库备份
CHCH998的博客
05-07 833
I am trying to restore a SQL Server backup file for my database, but it is throwing an error as fol
还原数据库：The backup set holds a backup of a database other than the existing database……
weixin_30448603的博客
11-06 180
还原数据库时报以上错误，解决办法是： 1、删除新建的DB 2、直接右键Databases-->Restore Database 3、在弹出窗口中的To database栏位填写需要新建的DB名称(不存的名称) 4、选择From Device 5、选择DB的.bak备份文件 完成！ 转载于:https://www.cnblogs.com/zyj649261718/p/49429...
SQL SERVER 2005恢复数据错误解决：The backup set holds a backup of a database other than the existing 'XXX' database
shuilv2000的专栏
03-29 1029
在sqlServer20005 的management studio里使用bak文件还原数据库的时候,总是失败!Restore failed for Server ADANDELI.  (Microsoft.SqlServer.Smo)An exception occurred while executing a Transact-SQL statement or batch. (Micros
The backup set holds a backup of a database other than the existing xxx database.
weixin_30376163的博客
08-01 172
http://blog.tangcs.com/2009/01/07/sql-server-restore-error/ 转载于:https://www.cnblogs.com/WarrenTang/archive/2009/01/07/1371114.html
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database
Shang的专栏
05-20 3270
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ databaseProblemYou have backup a database on SQL Server 2005. Then, you try to restore th
3154:Sql2005 恢复sql2000 数据库备份时出现的"3154"错误的解决The backup set holds a backup of a database...
weixin_30446197的博客
08-06 136
在sqlServer20005 的management studio里使用bak文件还原数据库的时候,总是失败! Restore failed for Server 'ADANDELI'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Mic...
io.lettuce.core.RedisCommandExecutionException: WRONGTYPE Operation against a key holding the wrong kind of value
最新发布
04-05
This exception is thrown when you try to perform an operation on a Redis key with the wrong type of value.... So, make sure to take a backup of your data before making any changes to your Redis database.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值