I have a SQL2k server running on Win2k,  I backup

(automated at 9:am daily) to my local PC HDD.  No

problem!!!!!



I have mapped a drive on the SQL server to a localy

shared folder.



I works for me !



>-----Original Message-----

>Hello folks,

> I think this issue must have been talked before and i

am sorry to raise it

>again but after having read at number of places i could

not find the

>solution and so i am posting the topic again. Hope i get

some help.

>Now i want to backup my database on a network.

>The operating system on which my SQL Server 2000 is

there is Windows 2000

>Server while i want to take the backup on another

computer on network which

>also has same operating system.

>Now whenever i try to take a backup on network with

command

>Backup Database databasename to

Disk='\\backup\tmp\networkdatabase.dat'

>i get following error in the Query Analyzer

>

>Server: Msg 3201, Level 16, State 1, Line 1

>Cannot open backup

device '\\backup\tmp\networkdatabase.dat'. Device error

>or device off-line. See the SQL Server error log for

more details.

>Server: Msg 3013, Level 16, State 1, Line 1

>BACKUP DATABASE is terminating abnormally.

>

>When i check the error in the sql server error log this

is what it says

>

>BackupDiskFile::CreateMedia: Backup device

>'\\backup\tmp\networkdatabase.dat' failed to create.

Operating system error

>= 1326(Logon failure: unknown user name or bad

password.).

>

>Now as i read at various place they say that to enable

backup on network you

>need to run the MSSQLSERVER service run under particular

account that has

>rights to take network backup.

>So i changes the "Log On" option from "Local System

Account"  to "This

>Account" in which i add the account that has the rights

to take the backup

>on the network.

>After doing this is restarted the server and then issued

the command for the

>backup.

>But still i am getting the same error.

>

>Also when i type in the \\backup\tmp in the run (Start -

Run) then i am able

>to access the server without asking for any username or

password. Also i am

>able to

>copy, write directly on that network server from SQL

server but when it

>comes to backup up from Query Analyzer, it gives me

error.

>Also i am connecting to QA under the "Windows

Authentication" mode only so

>even that is not a problem

>

>If any one has any idea as to where i am wrong or what

steps should i

>take/check to ensure that i am not missing anything

please let me know.

>Any help would be appreciated.

>

>Thank you

>

>

>.

>

http://www.devx.com/tips/Tip/5595



For SQL Server to perform a dump to a remote drive (that is, another machine on the network), the ID that SQL Server runs under must have rights to the drive. Otherwise you will get a permission error when attempting to dump. Go to Control Panel and click on the Services icon. Locate the MSSQLServer service and double-click on it. The service should use a user account, not the local system account. If you haven't done so yet, create an account for use by SQL Server. Grant it the necessary rights (it should at least be part of the local administrator group) on the local machine and the remote drive.