Getting error while restoring the sql database in sql 2008.

Question

0.00/5 (No votes)

See more:

SQL-Server-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.

Posted 18-Feb-14 2:54am

Appdev(Icode)

Updated 18-Feb-14 22:38pm

v2

Add a Solution

2 solutions

Solution 1

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?

Posted 18-Feb-14 2:58am

OriginalGriff

Comments

[no name] 18-Feb-14 8:59am

That is the exact path where my db is available..what ever path i give it keeps on showing the same error.

OriginalGriff 18-Feb-14 9:01am

What exactly do you mean "the exact path where my db is available"?
What command are you using?

[no name] 18-Feb-14 9:01am

While clicking on add button i'm getting error directly as follows

TITLE: Locate Backup File - HOME-PC\SQLEXPRESS
------------------------------

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

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

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

[no name] 18-Feb-14 9:02am

even though i specify full path nothing happens keep on showing error

[no name] 18-Feb-14 9:03am

in sql 2008

right click on databast -> select restore database -> from device -> ... ->then path of the file

OriginalGriff 18-Feb-14 9:12am

So this isn't C# then, you are doing this in SSMS, yes? Or VS?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2014-02-18T14:21:00

Solution 2

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.

Posted 18-Feb-14 14:21pm

ZurdoDev

Comments

[no name] 19-Feb-14 0:00am

Hi it was Resolved....Permission issues only thanks..

ZurdoDev 19-Feb-14 7:56am

OK. Good to hear.