Permisson on Harddisk

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben - 31 Oct 2005 15:51 GMT

I have a database on a secured server that I would like to have automatically
backed up. The problem is, this database must be backed up into a folder
with very limited access. What user name/id must be given in the security
properties of the folder to allow the sql agent to perform. I have tried a
few and none seem to work.

Thanks for any and all help!

Ben

Reply to this Message

Tom Moreau - 31 Oct 2005 16:01 GMT

Use the domain account under which SQL Server is running. Grant it
read/write access.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

>I have a database on a secured server that I would like to have
>automatically
[quoted text clipped - 7 lines]
>
> Ben

Reply to this Message

Geoff N. Hiten - 31 Oct 2005 16:10 GMT

Actually the account needs FULL CONTROL.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Use the domain account under which SQL Server is running. Grant it
> read/write access.
[quoted text clipped - 11 lines]
>>
>> Ben

Reply to this Message