January 26, 2005 at 10:18 pm
Hi,
I had to reinstall W2K Advanced and subsequently SQL 2000 onto the C drive of my server. My backups are on the D drive so I was able to restore my databases from the backup devices on the D drive. In Enterprise Manager I now see the databases with a (loading) beside each one. One of the DBs is 13GB and the other is approx 200MB. Is this normal and roughly how long should I expect to wait before the DBs show up properly?
Thanks,
Pat.
January 26, 2005 at 11:25 pm
I think you're not add the "WITH RECOVERY" option when you restore the database. The solution is, you just login to the database as database administrator (sa) and then you just type :
restore database [your database name] with recovery
after that go bak to the enterprise manager and see the database status.
btw, make sure that the database is finished for the restore process, because if you still have the database log file to restore, restore it first.
January 27, 2005 at 3:54 pm
Restore time is very hardward dependent. Especially if you have your data files lying on the same drive as your operating system (not recommended) you can expect your restore times to be substantial. For a 20 gig database I would not be suprised if the restore took between one and two hours.
The WITH RECOVERY option is the default for a restore command so as long as you didn't specify WITH NORECOVERY you should be fine.
My guess is that you just have to wait for the databases to finish restoring.
How long have you waited.
January 28, 2005 at 2:48 am
Thanks to both of you for your replies. I ran a default restore so I guess that was with recovery. My OS is on C which is a mirrored drive and my data is on D and backups on F. D and F are on a separate RAID 5 array. In the end what I discovered is that I didn't have enough space on D for the DBs and log files. Once I got around this the DBs restored fine.
Pat.
January 28, 2005 at 6:53 am
Just to provide a couple of comparison times ...
HP-DL-580 quad 3.0 Gh Xeon CPU, RAID 1 OS, separate RAID 5 SAN arrays for data, log and backup. Restore time for 10 Gb database 7-8 minutes with one dump file.
HP-DL-380 dual 3.0 Gh Xeon CPU, RAID 1 OS, separate RAID 5 SAN arrays for data, log and backup. Restore time for 10 Gb database 13-15 minutes with one dump file.
These times are based on actual times from a production and test server in my environment today.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply