-
Backing up data to network drive mapped
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.
-
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.
-
SQL Services
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.
-
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.
-
Have to change sql agent service account as well. Do it in em -> sql agent -> properties.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|