恢复数据库错误 [英] Restore database error

问题描述

在sql server 2005中还原数据库错误

如何还原数据库错误

Restore database error in sql server 2005

How to restore database error

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

Restore failed for Server ''kannan\SQLEXPRESS''.  (Microsoft.SqlServer.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 ''FinanceManagement'' database. (Microsoft.SqlServer.Smo)

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

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

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

推荐答案

错误消息非常不言自明-您正在尝试将数据库还原到其他数据库中.将其还原到原始数据库中，它应该可以正常工作.

The error message is pretty self-explanatory - you are trying to restore a database into a different database. Restore it into teh original database, and it should work fine.

从磁盘="Path"中使用replace
还原数据库数据库名.
运行此查询.

restore database databasename from disk=''Path'' with replace

Run this query.

这篇关于恢复数据库错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！