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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2006-08-01 : 04:39:07
|
| I have this morning "inhertited" a problemA db server was rebooted over night and now one of the databases is stuck at "Loading" (as reported by EM) ... and has been now for 9hrsThis is a much larger db than I am used to dealing with (the mdf is 26GB, I am used to 500MB) so I am not sure if this is normal... but 9hrs does seem a bit excessiveIs there anything I can do to find out what is going on and make that db accessible? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-01 : 06:09:09
|
| No it's nmot normal.Is it trying to recover large transactions?What happened last night?Is the server doing anything? i.e. is it still recovering that database - try looking at the diskio for the process.I would stop the server, copy the mdf to another server and try to attach it.You might find that when you restart the server it is ok.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-08-01 : 07:03:11
|
| Meantime I would suggest working out where the most recent backups, preceding the most likely cause of this problem, are. If they are on tape or off-site [i.e. NOT on local disks] I would start getting them restored to local disk - just in case!Kristen |
|
|
|
|
|
|
After restart DB stuck(?) at "Loading"