backup fails!!Urgent
-
Hi, I run this in query analyzer dump database MYDB to disk = 'c:\temp.dat' with init sql server fails to back up and returns Server: Msg 3202, Level 16, State 1, Line 1 Write on 'c:\temp.dat' failed, status = 64. See the SQL Server Error Log For More details. Server: Msg 3013, Level 16, State 1, Line 1 Backup Database is terminating abnormally Please help, this has to be resolved before production goes online on monday. Any hints will be highly appreciated. Thanks in advance.
-
Hi, I run this in query analyzer dump database MYDB to disk = 'c:\temp.dat' with init sql server fails to back up and returns Server: Msg 3202, Level 16, State 1, Line 1 Write on 'c:\temp.dat' failed, status = 64. See the SQL Server Error Log For More details. Server: Msg 3013, Level 16, State 1, Line 1 Backup Database is terminating abnormally Please help, this has to be resolved before production goes online on monday. Any hints will be highly appreciated. Thanks in advance.
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???