When restoring,does "processed" refer to db or backup size?

sql-loversql-lover Posts: 39
edited June 16, 2013 6:05AM in SQL Backup Previous Versions
Got a 1TB database that is currently being restored.

The backup is a replica of the actual database, so nothing is down, but restore has been running for 2hrs and RedGate says it has processed 120GB so far.

Is that 120GB against the backup size (~240GB) or it does refer to the 1TB database size?

I need to know so I can calculate how long would it take and if I have to stop the process and start early morning instead.
· Share on Twitter

Comments

  • RajKRajK Posts: 59
    I am contacting you in regards to this support case. Did you need any further support at this stage?

    I am the support engineer that is responding to this support case.

    What you have mentioned would be the percentage processed. Where are you seeing the 120GB processed info? Is this a restore being done via the gui?

    Normally restores via command line display as per below:

    7/2/2012 12:00:11 AM: Database size : 19.813 MB
    7/2/2012 12:00:11 AM: Compressed data size: 1.794 MB
    7/2/2012 12:00:11 AM: Compression rate : 90.94%

    7/2/2012 12:00:11 AM: Processed 1848 pages for database 'msdb', file 'MSDBData' on file 1.
    7/2/2012 12:00:11 AM: Processed 6 pages for database 'msdb', file 'MSDBLog' on file 1.
    7/2/2012 12:00:11 AM: BACKUP DATABASE successfully processed 1854 pages in 1.013 seconds (14.297 MB/sec).

    Thanks for your patience and feedback in this matter.
    · Share on Twitter
Sign In or Register to comment.