Using Network Shares with SQL Backup

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Using Network Shares with SQL Backup

Postby HJoyce » Thu Feb 16, 2006 5:52 pm

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.
HJoyce
 
Posts: 150
Joined: Mon Oct 10, 2005 9:48 am

Deleting Backups From the Share?

Postby charleyevans » Wed Nov 29, 2006 8:24 pm

I noticed that I can create backups using the UNC path to the share, as described in the preceding post. However, I've seen that I receive a 160 Error, unable to delete backups when trying to use ERASEFILES in a script. I checked and the files that should be deleted are in fact not deleted.

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.
Thanks,

Charles Evans
charleyevans
 
Posts: 11
Joined: Wed Nov 29, 2006 8:14 pm
Location: Austin, TX


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests