sqlServer2008 数据库"MyDatabaseName"备份文件名称: MyDatabaseName_20090320.BAK
错误信息如下:
The backup set holds a backup of a database other than the existing 'MyDatabaseName' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
原因:
备份的数据文件和日志文件与现有的数据库文件存放路径不一致;
解决办法:
1.新建一个同名数据库 MyDatabaseName;
2.执行下面的sql语句:
use master;
restore database MyDatabaseName from disk = 'd:\DBBackup\MyDatabaseName_20090320.BAK' with replace;