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 |
|
pcs001
Starting Member
6 Posts |
 Posted - 2010-08-04 : 14:30:11
|
| Hi,We ran into a problem where one of the table was too big and in an attempt to truncate it the script was hung up and then the databases would not open in Enterprise Manager. Anyone has any ideas? Thanks in advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-04 : 14:49:28
|
| can try killing the SPID.in Query analyzer, execute sp_who2 to find the offending spid. Check to see if it is blocked 1st |
 |
|
|
pcs001
Starting Member
6 Posts |
Posted - 2010-08-04 : 14:54:59
|
| My Query analyzer was timed out trying to connect to the databases. I found the SPID # in Enterprise Manager, tried to kill it but it didn't seem to be doing anything.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-04 : 15:02:53
|
| execute the kill again. it will tell you % completemay need to log into the server directly if cpu is pegged, which it probably is |
|
|
|
pcs001
Starting Member
6 Posts |
Posted - 2010-08-04 : 15:23:22
|
| I tried to kill it again and from 'Process ID' and 'Locks/Process ID', and neither of them did anything. I checked the cpu it was 99% idle. Someone told me that the database went into recovery mode and there was nothing that we could do about it right now. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-04 : 15:50:07
|
| u need to use QA not EM.99%, or 1%?Anyway, it is likely rolling back and you just have to wait for it. Still should log on directly at the server and see (using QA)But if something is blocking, you can kill the process that is doing the blocking. Also need to make sure there are no open transactions |
|
|
|
pcs001
Starting Member
6 Posts |
Posted - 2010-08-04 : 15:52:51
|
| But where can you see the % recovered and how much more time left to go? I guess it was showing up on the cpu chart because the recovery was running in the background... |
|
|
|
|
|
|
Can not open Databases in Enterprise Manager