sql 2005备份无法恢复 [英] sql 2005 backup can not be restored

问题描述

当我尝试从bak文件恢复数据库时，它显示此错误。我正在按照Internet中给出的正确过程进行操作。但是失败了。



< br $> b $ b



错误是------------------------- -------------------------------------------------- -----------

标题：Microsoft SQL Server Management Studio Express 
 --- --------------------------- 
 
服务器'HOME-674DF78993 \SQLEXPRESS'恢复失败。 （Microsoft.SqlServer.Express.Smo）
 
如需帮助，请单击：http：//go.microsoft.com/fwlink？ProdName = Microsoft + SQL + Server& ProdVer = 9.00.3042.00& EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText& EvtID = Restore + Server& LinkId = 20476 
 
 -------------------- ---------- 
附加信息：
 
 System.Data.SqlClient.SqlError：备份集包含现有SmsDatabase数据库以外的数据库的备份。 （Microsoft.SqlServer.Express.Smo）
 
如需帮助，请单击：http：//go.microsoft.com/fwlink？ProdName = Microsoft + SQL + Server& ProdVer = 9.00.3042.00& LinkId = 20476 
 
 ------------------------------ 
 BUTTONS：
 
 OK 
 ------------------------------ 

解决方案

请看这个帖子：



SQL SERVER - FIX：错误3154：备份集包含除现有数据库之外的数据库的备份

备份集包含除现有dbName数据库之外的数据库的备份 [ ^ ]



希望它有所帮助！ ：）

when I am trying to restore database from bak file it shows this error.I am following the correct process which is given in internet.But failed.




error is--------------------------------------------------------------------------------------

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'HOME-674DF78993\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'SmsDatabase' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

解决方案

Hi, Please see this thread:

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
The backup set holds a backup of a database other than the existing ‘dbName’ database[^]

Hope it helps! :)

这篇关于sql 2005备份无法恢复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！