How do I cancel pending jobs in the Log Copy Queue?

• 
  Try the following:
  
  EXEC master..sqbdata 'UPDATE backupfiles_copylist SET status = ''C'' WHERE ID = ...'
  
  You can find the IDs using the following to identify the pending tasks:
  
  EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist WHERE status = ''P'' '

  petey August 17, 2010 12:42

  - 0 +
• 
  Thanks for the reply.
  
  I ran EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist WHERE status = ''P'' ' and it returned no rows.
  
  So I ran:
  EXEC master..sqbdata 'SELECT status, count(*) FROM backupfiles_copylist group by status '
  
  and got:
  
  Status
  E 1346
  S 7996
  
  Is it safe to set all these to status 'C'?

  steverowlands August 18, 2010 07:29

  - 0 +
• 
  You don't have to. E = expired, S = successful. SQL Backup won't attempt to copy any of these files any longer.

  petey August 18, 2010 08:02

  - 0 +
• 
  Apologies, yes they have all gone from the list, looks like the last email alert we got was at 10:21 this morning which was about an hour before I checked the database.
  
  Thanks for the assistance with this.
  
  Steve

  steverowlands August 18, 2010 09:08

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too many mail alerts file already exists.. and i want clear all the files with in the range of IDs 

  luciano December 31, 2018 10:09

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too 

  luciano December 31, 2018 10:09

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too 

  luciano December 31, 2018 10:09

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too 

  luciano December 31, 2018 10:09

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too many mail alerts file already exists.. and i want clear all the files with in the range of IDs 

  luciano December 31, 2018 10:09

  - 0 +
• 
  what if i have many log backup files which were copied manually and later on job gets started to with network copy.
  Getting too 

  luciano December 31, 2018 10:09

  - 0 +
• 
  Changing to C didn't seem to work.  I'm finally getting e-mail messages that the 24 hour time limit has expired but I will probably be getting these for the next couple of hours.  

  SQL_Dude July 30, 2019 16:39

  - 0 +

Add comment

Please sign in to leave a comment.