Backup error with Access Denied

MichaelT · May 24, 2019, 7:57pm

I just sent the log to Developer. My application id is 351392f3-9888-4cd3-bc12-32486b615331

Could you please take a look for me why I got Access Denied?

Thank you

Alexander · May 27, 2019, 1:57pm

Hi MichaelT,

Thank you for the logs, we checked them. This issue happens during the deleting old backups. Could you please make sure that files for which you get “Access Denied” error message are on your destination place.

Sorry for the inconvenience.

MichaelT · May 28, 2019, 1:59pm

Hi Alex,

The file is there. Please see my image. So why is this error?

MichaelT · May 30, 2019, 1:27pm

@Alexander

Could you help with above post?

Thank you

Alexander · May 30, 2019, 3:11pm

Hi MichaelT,

Thanks for the details. It seems that the local system user hasn’t enough permissions for the removal. Could you please check this issue?

MichaelT · May 30, 2019, 3:23pm

@Alexander

Please see my images below with explanation.

So my local user is SQLBackupAgent as below

That local user SQLBackupAgent is a member of Administrators group

and the Administrators group has full permission to my backup folder

So that means the local user SQLBackupAgent should have the full permission to delete files from SQLBackups folder.

am I missing something here?

Alexander · May 31, 2019, 11:25am

Hi MichaelT,

Could you please make the following test:

Set “Run this job as user:” to default
Grant for “Local System” user all permissions for that folder

We need this test for further investigations.

Sorry for the inconvenience.

MichaelT · June 4, 2019, 3:18am

Hi Alex,

This wheel is disabled. I am not able to click on it to change “Run this job as user:”

MichaelT · June 4, 2019, 1:09pm

Alex,

I got it working now after I give account SQLBackupAgent full permission from the root folder. D:

Alexander · June 6, 2019, 9:29am

Hi MichaelT,

Good news! Thank you for your reply.

Please feel free to contact us on any issues or concerns.