Advertisement
goezler

stop backup jobs stucked at "Stopping"

May 14th, 2024 (edited)
434
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Backup your Veeam Backup Database
  2. Open your DB with pgAdmin
  3.  
  4. GO TO
  5. Servers > Postgresql 15  > Databases > YOUR_VEEAM_BACKUP_DB > Schemas > Tables > backup.model.jobsessions
  6.                        
  7.                         run following query
  8.                         SELECT * FROM public."backup.model.jobsessions" WHERE job_name = 'YOUR_BACKUP_JOB_NAME';
  9.                             //find the UUID with state 4 and copy uuid//
  10.                        
  11.                     //replace xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx with the copied uuid from first query and run following//
  12.                         UPDATE public."backup.model.jobsessions"
  13.                         SET state = -1
  14.                         WHERE job_name = 'YOUR_BACKUP_JOB_NAME' AND id IN ('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx');
  15.                            
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement