Error 605, Warning 600 Access is Denied- HELP

barrysbarrys Posts: 5
edited September 7, 2005 11:17PM in SQL Backup Previous Versions
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 = [[email protected]],
COMPRESSION = 3" -E'


PLEASE HELP!

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.