Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DrewBurlingame
Starting Member
49 Posts |
 Posted - 2002-05-22 : 21:01:59
|
| I think I just finished the restore successfully in QA. I got the follwing results:Processed 66704 pages for database 'Priya', file 'Priya' on file 1.Processed 3 pages for database 'Priya', file 'Priya_log' on file 1.Backup or restore operation successfully processed 66707 pages in 261.259 seconds (2.091 MB/sec).This is my first time using QA to do a restore. When I go to use the db or look at it via Ent Mgr, it says the db is "loading". It's been in this state for over 15 minutes now. Is this normal, considering the size? How long should I expect it to be "loading".Thanks for your help guys.Drew |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-22 : 22:59:04
|
| Right click and refresh.-Chad |
 |
|
|
DrewBurlingame
Starting Member
49 Posts |
Posted - 2002-05-23 : 02:46:09
|
| I did that many many many times. And rebooted.It turns out that this wasn't even a SQL Server issue. There was a VNC service running on the server that was consuming all the resources, so SQL never got to load the db. That explains why all my restores kept timing out.Sorry for the red herring all.Drew |
|
|
|
|
|
|
Restore Prod to Test problems: Part 2