-
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.
-
1. Make sure your sql server/agent is running under a domain account with access to the network share.
2. create a scheduled job as sa or equivalent with the following transact sql step
backup database yourdb to disk='\\yourserver\yourshare\yourdb.bak' with init
3. schedule it to run every night.
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
|
|