|
Posted by Wendy on 07/13/05 03:52
Whatever account you are using to start your MSSQL and SQL Agent services
must have access to the referenced share where you are backing up. If you
are using the local SYSTEM account to start the services it is not going to
work.
The way I do it is I have a SQL service account in my domain. I make that
account a System Admin in SQL (and many times a Local Administrator on the
SQL box) and then I give it full access the share I am trying to back up to.
"debian mojo" <debian_mojo@yahoo.com> wrote in message
news:WzSye.15$dl.5102@news.uswest.net...
> Hi again,
>
> Checked the error log and found this info:
>
> -----------------------------------------------------------
> 2005-07-06 19:47:13.48 spid60 BackupDiskFile::CreateMedia: Backup
> device '\\192.x.x.x\L\Data\test.bak' failed to create. Operating system
> error = 5(Access is denied.).
> 2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
> backup database test to pipedump
> -----------------------------------------------------------
>
> From what i could understand, there's a problem with access
> privileges! Anything else i should check?
>
> Thanks again and again
> Debian
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|