Per your previous post, you want to backup a database to another machine on
the network. If I understand you correctly, please try the following steps.
I have performed some test on this issue, and this job can be configured to
run automatically and successfully.
1. Share a folder on the destination machine.
2. Access this share folder on the source machine and right-click this
folder, then choose Map Network Drive to map this share folder on the
3. Create a job in the Enterprise Manager. Please make sure that the
startup account of the SQL Server Agent has the Full Control permissions on
that share folder.
4. Issue the backup statement as the job step statement and set the job
schedule. For example, assume that the mapping network driver is G.
backup database test_db
to disk = 'G:\bk_db.bak'
5. Save this job.
Please let me know if you have any further questions or concerns.
This posting is provided "AS IS" with no warranties, and confers no rights.