[Solved] System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database
Posted on 2010-04-18 12:58 饭后爱 阅读(3889) 评论(0) 编辑 收藏 举报当我想要恢复一个Database的时候,出现如下错误框:
错误信息如下:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server '######'. (Microsoft.SqlServer.SmoExtended)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'ReportServer' database. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
解决方案:
1, 在窗口 "Restore Database – ####" 中,选择"Options", 选中"Overwrite the existing database (WITH REPLACE)" 即可
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步