Restore Progress

chaoschaos Posts: 3
edited March 24, 2010 5:48AM in SQL Backup Previous Versions
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!)
““Our real discoveries come from chaos, from going to the place that looks wrong and stupid and foolish.””
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • chaoschaos Posts: 3
    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.
    ““Our real discoveries come from chaos, from going to the place that looks wrong and stupid and foolish.””
    · Share on Twitter
  • RBARBA Posts: 152 Silver 3
    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,
    Robin Anderson
    Development
    Red-Gate Software
    · Share on Twitter
Sign In or Register to comment.