Using Network Shares with SQL Backup

SQL Backup can create backups directly on a network share address. However, the startup user for the SQL Backup Agent Service must have Full permissions on the network share address.

The following procedure describes how you grant the permissions using Microsoft® Windows® XP; refer to your Microsoft Windows documentation for full details for your operating system.

In Windows Explorer, right-click on the folder in which you want to create the backups, and then click Sharing and Security.
Select Share this folder, and set the properties of the share as required.
Click Permissions, and on the Share Permissions dialog box, click Add.
On the Select Users, Computers, or Groups dialog box, grant full access to the account used by the SQL Backup Agent service.
Click OK on all of the dialog boxes.

For more information about the SQL Backup security model, see Security Model.