Backing up data to network drive mapped

[Sumana]

I am new to the DB Administration.

How do i back up the data to a network drive mapped on a day to day basis.

[rmiao]

First of all, have to start sql services with domain account that has permission on network drive. Then backup db with following statement:

backup database db_name to disk = '\\host\share\file_name' with ...

You can run it in query analyzer or schedule it as sql job.

[Sumana]

I have a sql server running on this system into which i am trying to map a drive. So now how do i start a sql service with a domain account that has permission on the network drive.

[skhanal]

create a domain account for the service using windows admin tool.

open sql server enterprise manager, right click on the server, go to properties - then security and type user name and password in start up service account boxes.

This requires sql server restart to take effect.

[rmiao]

Have to change sql agent service account as well. Do it in em -> sql agent -> properties.