How can we help you today? How can we help you today?

Restore Progress

The best way of obtaining progress information when doing a restore:

EXECUTE master..sqbstatus 1

If the processed column value is changing, it means the restore is underway.

The in progress tab is not very accurate.

-- From the RedGate Support team (They are super fast and great!)
chaos
0

Comments

3 comments

Sort by
  • petey
    If the processed column value is changing, it means the restore is underway.
    Not exactly true. In cases where SQL Server has to initialize the database files, the processed column will remain at 0 during that time. See Speeding up restores for details.

    Thanks.
    petey
    0
  • chaos
    Thanks for the additional info!

    It was showing a '0' in the processed column for a long time along with a ASYNC_DATAPOOL_WAIT in sysprocesses/status. I wondered what it was until I read your post. It feels great knowing this. Thanks again.
    chaos
    0
  • RBA
    Also, in the UI, if you select another server and then go back to the first one you will force a refresh of the in progress information. It's just as accurate as sqbstatus 1 (that's what it uses) but doesn't update that frequently.

    Regards,
    RBA
    0

Add comment

Please sign in to leave a comment.