Sql Server 2000、2005、2008，恢复备份数据库问题－Error:3154 _技术讨论
Paragraph details: | Posted by: 大头/小菜 | Categories: 技术讨论 | Browses: 533 | Posted Time: 2010-03-17
Sql Server2008恢复备份数据库问题－Error:3154
Sql Server2008恢复备份数据库问题：
问题描述：用Sql Server2008恢复数据库备份（使用sql server 2000 备份的）文件MyDatabase.BAK，报错如小：
The backup set holds a backup of a database other than the existing 'MyDatabase' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
解决办法：
1.新建一个同名数据库MyDatabase
2.执行下面的sql语句：
restore database MyDatabase from disk = 'C:\MyDatabaseBackup\MyDatabase.BAK'
with replace;