July 31, 2007 at 6:09 pm
I want to execute a CREATE DATABASE statement with size = 200GB. I will then do a restore from a back up of that size. Of course hardware varies on all machines, but how long should I reasonably expect the CREATE DATABASE statement to last?
July 31, 2007 at 8:09 pm
Depends on performance of your hard drives.
It needs to allocate 200GB.
So, it will take some time.
_____________
Code for TallyGenerator
July 31, 2007 at 10:27 pm
If memory serves, probably an hour or two.
As an aside, is there a reason you are creating the db in advance before doing the restore?
August 2, 2007 at 12:08 pm
A simple create on an HP DL-380 G5 attached to an EMC SAN should be less than 20 minutes.
A single threaded restore on the same type of server can achieve restore thoughput in excess of 1 Gb per minute on dual HBA's that are dual pathed - time about 70-80 minutes.
A striped (times 4) restore should be 60-70 faster than the single theraded restore just previously mentioned - time about 20-25 minutes.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 2, 2007 at 9:30 pm
SQL Server does not require you to create the database prior to restoring it. I would simply run the restore specifying the relevant file locations. It will still take a while for the restore process to initialise the files but it would have done this regardless of whether the database already existed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply