backup to network

[Former Member]

Hello,

I'm running 4.6c on sql server 2000 sp4.

i would like to back up my system through sql server db maintanance plan job to the network.

I mapped a network drive but when i'm required to give location for the target - i can't see the mapped drive.

is backup from the sql server itself possible only to local drives?

again - i'm not using third party backup system - i'm backing up from the sql server itself!

regards,

moshe

[clas_hortien]

Hi,

the startup account of the SQL Server have to have access rights to the network share and must be able to write to it. So you have to start the SQL Server under a domain account, as the local system has no rights in the network.

The easiest way to backup to a network share is:

backup database <DB> to disk = '
server\share'

Or you create a backup device with

exec sp_addumpdevice Disk,'<Logical Name>','
server\share'

You then can backup with:

backup database <DB> to <Logical Name>

Regards

Clas

[Former Member]

Hi Clas,

Does the domain account should have special permissions (admin) to run - don't forget that a sap system is running also on this machine.

Thanks for the fast reply

Moshe

[clas_hortien]

Hello,

the domain account should be member of the local admin group and has to have enough rights for the network share. The local rights should be the same as the local system account.

Regards

Clas