Re: Backup Database! this is really interesting!!

From: Ron Talmage (rtalmage_at_prospice.com)
Date: 12/12/04 

Date: Sat, 11 Dec 2004 17:21:55 -0800

I think Andrew is correct that it is a permissions issue. It works fine
locally on my machine.

Try this from Query Analyzer:
exec master..xp_cmdshell 'dir \\myserver\c$\temp.dat'
You should see the output of the dir command in the results pane.

Ron 

-- 
Ron Talmage
SQL Server MVP
"venAdder" <venAdder@discussions.microsoft.com> wrote in message
news:4AFC6143-1BC2-483C-AB63-DB4AFD398EE6@microsoft.com...
> If this is duplicate sorry, for some reason i don't see my posts on the
forum
>
> Ok I think I know what the problem is. Sorry for the 'c:\temp.dat'. The
path
> is actually
>
> '\\myserver\c$\temp.dat'. The status = 64 means The specified network name
> is no longer available ( ERROR_NETNAME_DELETED ). But the myserver is the
> name of the computer on which sql server runs. I mean sql server is
installed
> on myserver. So it should be same as saying c:\temp.dat.
>
> So the query becomes
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
>
> But in case of c:\temp.dat it succeeds and in case of
\\myserver\c$\temp.dat
> it fails ( it used to work, but ahs been failing recently).
>
> Now i tried following.
>
> 1. I am able to access c drive on myserver by typing \\myserver\c$ in
> windows explorer from another computer on LAN.
>
> 2. I am able to access c drive by typing \\myserver\c$ in the windows
> explorer on myserver.
>
> 3. ping 127.0.0.1 return normal results on myserver.
>
>
> So why does windows generates ERROR_NETNAME_DELETED when i run
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
> in query analyzer???
>