How can we help you today? How can we help you today?

130 error (access is denied.)

Hi all,

Thank you in advance.

I am in the process of moving all native SQL logshipping to backuppro and at the very first attempted I am getting warning error 130 <sharefolder> (access is denied.) during the restore. The restore is successful just the moveto is failing. I can manually move the files to the proccessed folder with the same windows login.
The share folder is not the same as the processed folder. See below.

Any ideas why the files are not moving?

EXECUTE master..sqlbackup '-SQL "RESTORE LOG &#91;AutoCheckIntegration&#93; 
FROM DISK = ''\\sql-host\logshipping\autocheck\LOG_AutoCheckIntegration_V5_*.sqb''
 WITH STANDBY = ''G:\MSSQL\Backups\UNDO_AutoCheckIntegration.dat'',
  DISCONNECT_EXISTING, moveto = ''G:\MSSQL\Backups\''"', @errorcode OUT, @sqlerrorcode OUT;
kimo
0

Comments

2 comments

Sort by
  • petey
    Does the SQL Backup Agent service startup account have rights to write to the G:\MSSQL\Backups folder?
    petey
    0
  • kimo
    Thank Petey.
    Right on the money. The backup agent was using the local system account once changed the warnings disappeared.
    kimo
    0

Add comment

Please sign in to leave a comment.