Red Gate forums :: View topic - Using Network Shares with SQL Backup
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Using Network Shares with SQL Backup

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Thu Feb 16, 2006 5:52 pm    Post subject: Using Network Shares with SQL Backup Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
charleyevans



Joined: 29 Nov 2006
Posts: 11
Location: Austin, TX

PostPosted: Wed Nov 29, 2006 8:24 pm    Post subject: Deleting Backups From the Share? Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group