Database '(In Recovery)'

[djj55]

Hello, We had a failure this morning and I have two SQL 2000 databases that say (In Recovery). How do I get them to be accessible?

Thanks
djj

 

[JayKusch]

What that is telling you is that the database(s) is/are rolling transactions forward and back depending on the start of the work in process when the server crash/was taken down.

You can look in the SQL Event Log and see at what percentage is it complete.

Remember that the SQL log does not dynamically update for you so you will need to hit refresh to see where it is as time progresses.

If at all possible ... let it do its business.



Thanks

J. Kusch

 

[djj55]

Thanks. I used RECOVER DATABASE mydatabase WITH RECOVERY to get them into an active state. The problem was with one it was indicating that someone was using it and I had to kill some connections before the command would work.

djj