GUI falsely reports job in progress

• 
  I stopped the SQL Backup Agent service and restarted. Problem solved.

  degnoski May 27, 2011 11:10

  - 0 +
• 
  We encountered a similar error today where it appeared as if a Txn log backup was still processing from 4 days ago, even though the job history did not indicate an error. I closed the client and opened it back up and it disappeared.
  
  We are doing backups with VERIFY_ONLY. Is there a fix/patch in place to resolve this issue or do we need to turn off the VERIFY_ONLY option?
  
  (SQL Server 2005 with SP4 32bit Clustered)
  
  
  Regards.
  
  Paul

  hitsgdba April 26, 2012 11:32

  - 0 +
• 
  hitsgdba,
  
  Yous don't mention what version you are running other than the possible subject line.
  
  We are running 6.5.2.9 and have this happen every so often. We even added a VERIFYINTERVAL parameter as we had been told it might help with this issue.
  
  Chris

  ChrisAVWood April 26, 2012 16:48

  - 0 +
• 
  6.5.1.9 is the version we are on. Here are the parameters from the job.
  WITH ERASEFILES = 3, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 0, INIT, THREADCOUNT = 7, VERIFY

  hitsgdba April 27, 2012 09:16

  - 0 +
• 
  I think that it was 6.5.2.9 that introduced VERIFYINTERVAL. I am sure that a Red Gate support analyst will confirm. It delays the time at which the verify process begins so that data in cache can be written to disk if I rememebr correctly. I also think that there is a later version 6.5.2.18 that may have other improvements for the verify process.
  
  You might also be able to try V 7 that came out earlier this week.
  
  Chris

  ChrisAVWood April 27, 2012 10:23

  - 0 +

Add comment

Please sign in to leave a comment.