On 1/3/07, Michael Parker <[EMAIL PROTECTED]> wrote:
Big Wave Dave wrote:
>
>
> What am I missing?
>
> I'd be thankful for any input.
You're not missing anything. The import takes a long time to run. Its
doing a lot of updates which are expensive in SQL. The good news is
that you can pretty much use the system while its doing the import
because everything is atomic.
There might be some tuning you could do on your database side that would
speed things up, but that is a much larger discussion.
Michael
It finally finished the restore.
For the sake of information to help future users....
The "backup" file being used to restore into the new SQL database was
99MB and took 17hrs to import on my AMD 1.2Ghz machine with 1GB of
RAM.
Dave