"Bulk" cancel pending uploads in 'In Progress'

JanusGjesager

I have about 5.000 jobs pending upload in the 'in progress' tab, going back 1 week.

Can I delete them all at once?

How can i troubleshoot why there seams to be no connection to AWS?

Dan B

Hi JanusGjesager.

You can use the sqbdata command to inspect the relevant tables, and delete the ones you don't want to upload anymore, or set the status to expire, so no further uploads are attempted.
To view all pending jobs:

EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist WHERE status = ''P'' ORDER BY created DESC'

To set these jobs to expire:

EXEC master..sqbdata 'UPDATE backupfiles_copylist SET status = ''E'' WHERE status = ''P'' '

On a related note, uploads jobs are set to expire automatically after 2 days, so there may be an issue with the internal copy engine. You may want to check if the bugreport.txt file was generated due to a crash. This would be located in: C:\ProgramData\Red Gate\SQL Backup\Log\(local)
SQBCoreService_<instancename>_bugreport.txt

To view any recent error entries in the upload logs:

EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist a INNER JOIN backupfiles_copylist_log b ON a.id = b.copylist_id WHERE a.created >= ''2017-11-12'' AND b.success = 0 ORDER BY a.created DESC'

JanusGjesager

Thanks.

The issue was resolved when restarting services on the servers. After that the files started uploading -