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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2004-01-22 : 07:17:35
|
| Hi,I am not able to see the databases in the enterprise manager. The current activity tell tht, one of the database is continuously recovering. on running the command 'sp_who', the process id 10 says, its awaiting command. Few processes are blocked on the server.How do we sort this out?Thanx |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-01-22 : 07:41:09
|
| You can wait for the recovery to finish, the log file should tell you the percentage completeness, or you can shut down the server, and delete or move the offended database LDF and MDF files, and then restore that from backup.-------Moo. :) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-22 : 12:39:33
|
| Wait for it to finish recovering. It must be doing a huge rollback or something like that. You have to let it finish. I've seen a database take over an hour to complete. This was on a server that had databases over 100GB. Typically they came up quick, but someone had rebooted the server in the middle of a massive delete.Tara |
|
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2004-01-23 : 01:02:54
|
| Thanx a lot , i just stopped the server and restored the database.( in our case the database was recovering for 4hours, so had to stop and carry on):) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-23 : 12:18:45
|
| I guess you didn't mind the data loss then.Tara |
|
|
|
|
|
|
recovery of database- continuously