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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-15 : 09:27:57
|
JasonB writes "Running SQL Server 7 on an NT4sp6a server:
I have restored a SQL7 database from a .BAK dump file (there are 4 additional transaction log dump files also to be restored), and everything seems OK. I can see the restored database in the Databases part of Enterprise Manager, but it appears in a grey colour with (Loading) after the database name. The dump file was approximately 400MB in size, so the database is not huge by any means, and I am concerned that it is not doing anything at all. The Task Manager shows CPU activity to be mostly idle and memory usage to be low, and while there are sqlmangr.exe and sqlservr.exe processes running, they do not appear to be using CPU resources.
When I performed the restore operation, I selected the 'Leave database nonoperational, but able to restore additional transaction logs' option, as I knew I have these other 4 logs to restore.
I'm not sure what to do - do I wait for the 'Loading' to complete (although I'm not sure its doing anything), or do I restore my transaction logs in order, setting the 'Leave database operational' option on the last one.
Sorry if this is a simple question, but I'm kind of stuck and finding advice hard to come by.
Thanks a lot." |
|
|
|
|
|
SQL 7 restore process