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.
Printable View
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.