问题描述:用Sql Server2005恢复数据库备份文件如(Data.BAK),报错如小:

The backup set holds a backup of a database other than the existing '' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)

 解决办法:

1.新建一个同名数据库Data

2.执行下面的sql语句:
restore database Data from disk = 'C:\KyjData\Data.BAK'

with replace;

posted on 2009-06-15 20:22  轻狂如我,奋华图强  阅读(1743)  评论(0)    收藏  举报