charipg (3/24/2010)
Hi,Database is in recovery status.
I dont know why it is showing recovery status.
I tried to do detach,offline and drop then every time i am getting error as "The database is in use".But the database is not in use.
Please advice how its bring back to online.
Thanks,
Chari
first why its goes restoring state?(is any one run the restore script)
Check the sql server errorlog,application logs too
The think is someone is using the database that's why its throwing error
find which user is connecting and kill that user using who2 or sysprocesses.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/