Red Gate forums :: View topic - 130 error (access is denied.)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

130 error (access is denied.)

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kimo



Joined: 09 Jan 2013
Posts: 2

PostPosted: Wed Jan 09, 2013 6:22 am    Post subject: 130 error (access is denied.) Reply with quote

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:
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;
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Jan 09, 2013 2:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
kimo



Joined: 09 Jan 2013
Posts: 2

PostPosted: Thu Jan 10, 2013 1:27 am    Post subject: Reply with quote

Thank Petey.
Right on the money. The backup agent was using the local system account once changed the warnings disappeared.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group