备份文件还原期间的SQL Server错误 [英] Sql Server Error During restore of a back up file

问题描述

我想在新数据库中还原备份文件，此错误是由sql server生成的:-
标题:Microsoft SQL Server Management Studio Express
------------------------------

服务器"HP-PC"的还原失败. (Microsoft.SqlServer.Express.Smo)

要获取帮助，请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText& amp; EvtID = Restore + Server& LinkId = 20476

------------------------------
其他信息:

System.Data.SqlClient.SqlError:文件"E:\ DATA \ DPIDataSQL.mdf"的目录查找失败，出现操作系统错误2(系统找不到指定的文件.). (Microsoft.SqlServer.Express.Smo)

要获得帮助，请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
按钮:

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

I want to restore the back up file in a new database this error is generated by sql server :-
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server ''HP-PC''. (Microsoft.SqlServer.Express.Smo)

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

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

System.Data.SqlClient.SqlError: Directory lookup for the file "E:\DATA\DPIDataSQL.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Express.Smo)

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

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

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

推荐答案

使用攻击而不是还原.数据>附加> E:\ DATA \ DPIDataSQL.mdf

谢谢，
Mamun

Use Attatch rather restore. Databaes>Attach>E:\DATA\DPIDataSQL.mdf

Thanks,
Mamun

您是否访问过提供给您的任何帮助链接?如果是这样，他们告诉了你什么?

附加信息"明确指出它找不到"E:\ DATA \ DPIDataSQL.mdf".那么您的路径正确吗，文件是否在该位置?如果不是，那就是造成您问题的原因.
此 [ ^ ]有逐步的指南，应该会为您提供帮助.

And have you visited any of the help links that were given to you? If so, what did they tell you?

The ''ADDITIONAL INFORMATION'' clearly states that it cannot find "E:\DATA\DPIDataSQL.mdf". So is your path correct and does the file exist at that location? If not then that is the cause of your problem.

This[^] has a step-by-step guide, which should help you.

这篇关于备份文件还原期间的SQL Server错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！