在sql 2008中恢复sql数据库时出错。 [英] Getting error while restoring the sql database in sql 2008.

问题描述

我在恢复数据库时遇到以下错误。

可以任何一次请弄明白。

hi i'm gettin the following error while restoring the database.
can any once please figure it out.

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

Cannot open backup device 'd:\'. Operating system error 3(The system cannot find the path specified.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476

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

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

提前感谢。

thanks in advance.

推荐答案

嗯。你确实指定了文件的正确路径？

因为错误很明确：D：\不存在......你假设某些硬件不在你的生产/开发SQL服务器上，或者在你的PC上但是是不在服务器上？

Um. You did specify the right path to the file?
Because the error is quite explicit: "D:\" does not exist...are you assuming some hardware which is not on your production / development SQL server, or that is on your PC but isn't on the server?

如上所述，错误是明确的。它找不到路径，因为它不存在，它没有权限查看它，或者其他一些原因。

As stated, the error is clear. It can't find the path because it does not exist, it does not have permissions to see it, or some other reason.

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