130 error (access is denied.)

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

130 error (access is denied.)

Postby kimo » Wed Jan 09, 2013 6:22 am

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?


Code: Select all
EXECUTE master..sqlbackup '-SQL "RESTORE LOG [AutoCheckIntegration]
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
 
Posts: 2
Joined: Wed Jan 09, 2013 6:08 am

Postby petey » Wed Jan 09, 2013 2:13 pm

Does the SQL Backup Agent service startup account have rights to write to the G:\\MSSQL\\Backups folder?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby kimo » Thu Jan 10, 2013 1:27 am

Thank Petey.
Right on the money. The backup agent was using the local system account once changed the warnings disappeared.
kimo
 
Posts: 2
Joined: Wed Jan 09, 2013 6:08 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests