Re: Backup Issue! Interesting or weird - you decide!

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/12/04 

Date: Sun, 12 Dec 2004 10:57:41 -0000

Hi

The service account is the account that the SQL Server service runs under.
See the services applet to see the account details. You can then use that
account to log into the system and try to map to the share.

Dump is only available on version after SQL 6.5 for compatibility, there are
no long term commitment to keeping it, therefore it should be changed.

That fact that it seems to work elsewhere does tend to imply a change
external to SQL Server has caused the problem. You may want to check the
event log for the first occurence of this error and see if any other
activities were happening at that time.

John

"venAdder" <venAdder@discussions.microsoft.com> wrote in message
news:4300ADCD-0AF1-459A-87F2-0BF89A333FCB@microsoft.com...
> backup database statement does same thing
> and dump has been working fine till now
> and anyways the computer is not a network computer it is the same computer
> on which server tries to backup . the reason why \\myserver\c$ is used is
> cuz
> someone was too lazy to check in the app if the server is local or remote,
> so
> let's not go there.\
> The point is it has been working fine till date and it works fine still on
> a
> number of other locations thruout US
>
> what is service account?
>
>
> "John Bell" wrote:
>
>> Hi
>>
>> Has the SQL Server service account been changed to a non-administrator?
>> The
>> use of DUMP would imply SQL Server 6.5 or earlier and I don't know if
>> shares
>> were allowed in those versions as a device, if version 7 or later use
>> backup
>> instead.
>>
>> John
>>
>> "venAdder" <venAdder@discussions.microsoft.com> wrote in message
>> news:9B67F0FE-B642-4353-87E9-D69266A300B4@microsoft.com...
>> >I run this query in query analyzer
>> > dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
>> >
>> > 'I get following error.
>> > 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.
>> >
>> > 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
>> >
>> >
>> > 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???
>> >
>> > P.S. : this works fine
>> > RESTORE DATABASE MYDB FROM DISK = '\\myserver\c$\temp.dat'
>> >
>> > So guess access is not an issue.
>>
>>
>>

Relevant Pages

  • Re: 2005 Enterprise sp 2 install fails - 11009
    ... Q...Was your SQL Server service account a domain administrator account? ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL windows account
    ... > Can the account to run SQL server belong to USER group or ... >>SQL Service account absoloutely does NOT have ... >>Jasper Smith (SQL Server MVP) ... >>> I happened to be a box and DB admin and i have a local ...
    (microsoft.public.sqlserver.security)
  • Re: Backup Issue! Interesting or weird - you decide!
    ... The service account is the account that the SQL Server service runs under. ... Dump is only available on version after SQL 6.5 for compatibility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 0x80070534 when changing service account
    ... When you removed the prefix, ... The account has granted Logon as Service right in the domain and in Domain ... The only difference I see is that the SQL Server where the account is ... service account using the Configuration Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to Backup on Network
    ... For SQL Server to perform a dump to a remote drive (that is, ... should use a user account, ... necessary rights (it should at least be part of the local administrator ...
    (microsoft.public.sqlserver.security)