having issue in database backup

Question

3.50/5 (2 votes)

See more:

SQL-server-2000

I want to take database backup on network. There are number of terminals like pc01, pc02 , pc10, & pc51. I taking backup from pc 51 on pc 01. Error is coming. whilst taking from pc 51 on pc 02 & other, it is happening sucessfully.

Error is

CSS

DatabaseName backup failed, Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on '\\PC01\c:\nexback\PC51.dat' failed, status = 64. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.

Please tell what is the reason and how to rectify.

Posted 3-Sep-13 0:56am

Member 10249450

Add a Solution

Comments

Member 10249450 3-Sep-13 7:43am

have changed in this format \\PC01\c$\nexback\PC51.dat, server connecting and start backup on location, after completing few kb, prompt error.

2 solutions

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)

OriginalGriff · Answer 1 · 2013-09-03T01:10:00

Solution 1

We can't - it's a generic error message.
Look at it though: it tells you what to do: "See the SQL Server error log for more details."

Hopefully, there will be sufficient information there to let you know what the problem is, if not solve it directly!

Posted 3-Sep-13 1:10am

OriginalGriff

Comments

phil.o 3-Sep-13 7:33am

Reason of my vote of 2 : despite the advise to go and see the log for more details is perfectly valid, the error message is in itself documenting enough : it shows a wrong UNC path.

phil.o · Answer 2 · 2013-09-03T01:26:00

\\PC01\c:\nexback\PC51.dat

Try to replace it with

\\PC01\c$\nexback\PC51.dat

You cannot access a hard drive on a distant computer the same way as you do on a local one.
Administrative shares have to be activated on the distant computer (and the user who tries to access them has to be a member of the local administrators group on the distant computer).