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

Compresses, encrypts, secures and monitors SQL Server backups.

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

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

Postby sql-lover » Wed Jun 05, 2013 10:38 pm

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.
sql-lover
 
Posts: 17
Joined: Tue Feb 12, 2013 9:26 pm

Postby RajK » Sun Jun 16, 2013 11:05 am

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.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest