May 15, 2008 at 9:31 am
How much time would it take to Restore a Database from Full Back from
Remote Location to a server on different location.
DB Size - 100 GB Approx.
Back UP File size- 20 GB
Give me some good Tips for this process to make this Job faster and Easier.
May 15, 2008 at 3:41 pm
restoring 20GB take no more than 20 minutes, the only time u need to shorten is Transferring the back file on the network.
..>>..
MobashA
May 15, 2008 at 4:17 pm
It _should_ complete in around twenty minutes. However, there are far to many variables to take into consideration for a hard number...
Network speed (for either backup copy or network based restore) is a major factor. The OP also mentioned that it was a 100GB database w/20GB of data - Instant File Initialization can create a large time variance when chunking out the disk for the database create portion of the restore op. The number of backup files as well can have a big impact on restore times. Not to mention variances in disk subsystems...
Std. answer is: "It depends". 🙂
Your friendly High-Tech Janitor... 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply