Remote backup not working

Question

Remote backup not working

govind-211283

SSC Eights!

Points: 962
More actions
July 25, 2005 at 9:56 am

#111346

Hi,
I've 2 servers at 2 different locations, at one location the server is taking the remote backup smoothly. But on another location it says:
Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device '\\192.168.246.22\sqlbk\lhrcp.bak'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
What wrong I'm doing here. Although I can access this path and i've full access there.
Govind

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kozloski SSC Eights! Points: 804 More actions · Answer 1

You generally need to have the SQL Server running under a domain user account for it to be able to access network resources, such as file shares. So, although you can access the path, the SQL Server can't because it's running as the local system account (NT AUTHORITY\SYSTEM)

Check the account the working server is running as, I'll bet it's not the system account.

In Enterprise Manager: Right-click the server, select properties. Then select the Security tab, and check the Startup service account near the bottom of the dialog.

You'll also probably want to check the same on the SQL Server Agent, since it runs as a separate service. Right-click the SQL Server Agent, select properties, and it's the first thing you see on the General tab.

Hope this helps!

-- J.Kozloski, MCDBA, MCITP

swjohnson Hall of Fame Points: 3254 More actions · Answer 2

Also, don't forget to make sure that the domain account has the proper permission on the network drive where you are trying to write the file.

SJ

Accepting all invites

SQLBill SSC Guru Points: 51440 More actions · Answer 3

The error message said to check the SQL Server Error Log for more information, did you do that?

Also check the Windows Event Viewer logs as there may be more information there as to what went wrong.

-SQLBill

Jason Hall Hall of Fame Points: 3906 More actions · Answer 4

look for a loss of network connection in the windows event log. This should isloate any issues related to lost network drives?

Has this backup been successful in the past or are you trying to initially set it up.

govind-211283 SSC Eights! Points: 962 More actions · Answer 5

Thanks all,

Finally I successfully took backup on remote location by mapping a drive from Sql server. But initially when it was taking backup on network, the server got lots of network problem - upon completion of backup my server was not responding to anyone untill someone restart it. So now I'm quitely taking backup on local location and after that process I've copying that folder to remote location through a batch program

And they live happily ever-after.

Thanks again for replying yours' replies have guide me many things,

Govind