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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2010-04-25 : 06:19:19
|
| My database is stuck in recovery mode after a reboot.I tried rebooting again with the hope that any previous rogue processes would get killed, but it has obviously not happened.Is there anything other than restore of database thatcan work here?The funny thing is, the completion percentage of database went upto 82%, then came back to 45 suddenly and started going down, all the way to 18 before rising and staying stuck at 25...Any help is welcome..RegardsParesh MotiwalaBoston, USA |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-04-25 : 06:46:43
|
From where did you get the idea for another reboot would solve the problem?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-25 : 06:55:12
|
| Recovering or restoring?If recovering, there'll be messages in the log saying how far along the recovery is. The only thing you can do is wait (rebooting will just start it over from scratch)You may want to check that there's no IO-intensive processes running other than SQL. If the disks are slow, recovery will take longer than expected (which can cause the erratic completion % that you see)--Gail ShawSQL Server MVP |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2010-04-25 : 09:46:12
|
| sorry folks, thanks for the help.Peso, it was more of a hope(as in case of all MS issues).The server has superb SAN, and 16GB RAM and 8 CPUs... so there was not resource contention for sure.I suspect that the re-indexing job for the database was terminated after about 4 hours. then, we applied some Windows patching and rebooted the server....after reboot the thread for re-indexing must be doing something, not sure..it was 7:30AM when I have up. took the SQL Service down, renamed the files. Restarted the Service, and restored the database from the backup taken earlier today at 12:40AM.The operation is successful, but the patient is dead...Thanks for your responses folks.cheers.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
|
|
Database Stuck in Recovery Mode