Red Gate forums :: View topic - When restoring,does "processed" refer to db or backup size?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

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

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sql-lover



Joined: 12 Feb 2013
Posts: 17

PostPosted: Wed Jun 05, 2013 10:38 pm    Post subject: When restoring,does "processed" refer to db or backup size? Reply with quote

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.
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Sun Jun 16, 2013 11:05 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group