restore database status still in progress after failure

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey, JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

restore database status still in progress after failure

Postby normpang » Thu May 08, 2014 9:38 am

after a failed restore, I can see status of the restore of the database to be still active in the "In Progress" tab.

How do I remove this status?

I'm using SQL Backup 7.6.0.26 on a 2008 R2 database.
[/img]
normpang
 
Posts: 2
Joined: Thu May 08, 2014 9:25 am

Postby eddie davis » Fri May 09, 2014 3:56 pm

Thank you for your forum post.

I suspect it is nothing to worry about, as the GUI ->In Progress Tab is slow to update and clear when a job completes. Also it is not an accurate way of checking if a task is still running.

If you close the GUI and re-open after a couple of seconds, is the Failed restore still displayed in the In-Progress tab?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby normpang » Tue May 13, 2014 12:53 pm

thanks Eddie but the status is 0 B processed, with an action of Restore. The green circle is spinning.

I've restarted the GUI a few times.

Is there a way of removikng this status?
normpang
 
Posts: 2
Joined: Thu May 08, 2014 9:25 am

Postby eddie davis » Wed May 14, 2014 12:29 pm

Thank you for your reply.

Can you please run the following query on the restoring server to ensure that a restore task is actually running:

Code: Select all
USE master
GO
EXECUTE Master..sqbstatus 1
GO


If no backup or restore task is running, zero results are returned. The entry in the GUI is false. Normally closing and reopening the GUI resolves the problem.

If a set of results are returned, this indicates that there is a restore process running. The results will include database name, login used, process - B = backup and R = restore, type, compression, encryption. The columns of interest are Processed (bytes), Compressed (bytes) and start_date.

If you repeat the query 2 or 3 times does the processed (bytes) value increase?

If the restore process is running, please run the following two queries and save a copy of the results.


Code: Select all
USE master
GO
EXECUTE master..sqbutility 9997
GO


This function will provide a debugging trace of the current execution process in the SQL Backup engine.

Executing sqbutility 9997 will return a NULL value and generate a file in the named directory for the corresponding SQL Backup Agent (eg by default, C:\\Program files\\Red Gate\\SQL Backup\\%instance%, called "SQBCoreService_bugreport.txt"

Code: Select all
USE master
GO
EXECUTE sp_who2
GO


Executing sp_who2 will return a list of the current processes in the SQL Server engine. Please save a copy of the results.

A support call has been created for you and is available using this LINK. If you have not already done so, you will need to create a redgate ID to view and update the support call. Please update the call with sp_who2 results and the SQBCoreService_<instance name>_bugreport.txt file.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests