首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 其他教程 > 其他相关 >

复原出错:the backup set holds a backup of a database other than the existing

2012-07-18 
还原出错:the backup set holds a backup of a database other than the existing,mssql server 2005还原

还原出错:the backup set holds a backup of a database other than the existing,
mssql server 2005还原出错:the backup set holds a backup of a database other than the existing,error:3154

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

restore database Testfrom 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'

热点排行