Error 605, Warning 600 Access is Denied- HELP

barrys

I'm trying to backup to a newtwork shared folder. I am running the wscript as an admin user with full rights to the shared network folder but yet I am getting this error:

---

9/7/2005 6:29:10 PM: SQL Backup 3.2.0.5, (c) Red Gate Software Ltd 2004 - 2005
9/7/2005 6:29:10 PM:
9/7/2005 6:29:10 PM: Backing up BEMetaData (full database) to \\SHAREDSERVERNAME\XXX\XXX_FULL.sqb ...
9/7/2005 6:29:10 PM:
9/7/2005 6:29:10 PM: BACKUP DATABASE [BEMetaData] TO DISK = '\\SHAREDSERVERNAME\XXX\XXX_FULL.sqb' WITH NAME = 'Database ', DESCRIPTION = 'Backup of Database(local) Server: XXX', INIT, ERASEFILES = 1, COMPRESSION = 3
9/7/2005 6:29:10 PM:
9/7/2005 6:29:10 PM:
9/7/2005 6:29:11 PM: Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
Thread 0 warning:
Warning 600: Error creating backup file: \\SHAREDSERVERNAME\XXX\XXX_FULL.sqb
Warning: System error code: (Access is denied)

---

Here is the SQL I am using:
master..sqlbackup '-SQL "BACKUP DATABASE [XXX]
TO DISK = [\\SHAREDSERVERNAME\XXX\XXX_FULL.sqb]
WITH NAME = [Database (XXX)],
DESCRIPTION = [Backup of Database Instance: (local) Server: XXX],
INIT, ERASEFILES = 1,
MAILTO_ONERROR = [XXX@XXX.com],
COMPRESSION = 3" -E'

---

PLEASE HELP!

petey

When you run SQL Backup through the extended stored procedure, it uses the rights of the SQL Server service startup account to perform any file operations. This service startup account most probably does not have rights to the network share.

To use the rights of the wscript user, use the command line interface instead.