Red Gate forums :: View topic - GUI falsely reports job in progress
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

GUI falsely reports job in progress

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
degnoski



Joined: 27 May 2011
Posts: 2

PostPosted: Fri May 27, 2011 2:43 pm    Post subject: GUI falsely reports job in progress Reply with quote

A t-log backup runs every two hours for several months. Suddenly the job is not running but the SQL Backup V6.3 gui says it's in progress. This has been going on for several days now. SQL Server indicates that the job is not running. I deleted the job from SQL Backup but the gui still reports the job in progress. I created a new job to replace the problem job and it is running fine. How do I force the gui to end(release) this job?
Back to top
View user's profile Send private message
degnoski



Joined: 27 May 2011
Posts: 2

PostPosted: Fri May 27, 2011 4:10 pm    Post subject: Fixed Reply with quote

I stopped the SQL Backup Agent service and restarted. Problem solved.
Back to top
View user's profile Send private message
hitsgdba



Joined: 26 Apr 2012
Posts: 2

PostPosted: Thu Apr 26, 2012 4:32 pm    Post subject: Is this error been fixed in 6.5.1.9 Reply with quote

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
Back to top
View user's profile Send private message MSN Messenger
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Apr 26, 2012 9:48 pm    Post subject: Reply with quote

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
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
hitsgdba



Joined: 26 Apr 2012
Posts: 2

PostPosted: Fri Apr 27, 2012 2:16 pm    Post subject: Backup Pro Version Reply with quote

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
Back to top
View user's profile Send private message MSN Messenger
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Fri Apr 27, 2012 3:23 pm    Post subject: Reply with quote

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
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group