Options
Using Network Shares with SQL Backup
HJoyce
Posts: 186
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.
1. In Windows Explorer, right-click on the folder in which you want to create the backups, and then click Sharing and Security.
2. Select Share this folder, and set the properties of the share as required.
3. Click Permissions, and on the Share Permissions dialog box, click Add.
4. On the Select Users, Computers, or Groups dialog box, grant full access to the account used by the SQL Backup Agent service.
5. Click OK on all of the dialog boxes.
The following procedure describes how you grant the permissions using Microsoft® Windows® XP.
1. In Windows Explorer, right-click on the folder in which you want to create the backups, and then click Sharing and Security.
2. Select Share this folder, and set the properties of the share as required.
3. Click Permissions, and on the Share Permissions dialog box, click Add.
4. On the Select Users, Computers, or Groups dialog box, grant full access to the account used by the SQL Backup Agent service.
5. Click OK on all of the dialog boxes.
Helen Joyce
SQL Backup Project Manager
Red Gate Software
SQL Backup Project Manager
Red Gate Software
Comments
Both my account and the account the SQL Backup Service runs under are configured with full permissions on the share. I can go to the share through Windows Explorer using the same path and delete the files manually without issue.
Is this a known issue with SQLBackup? Are there any known workarounds? Any help in this is greatly appreciated.
Charles Evans