Suresh B. (2/7/2013)
The message in the SQL Server log might not be related the database status.Is the database Log-Shipped (Secondary Server)?
Following command is used to bring the database online:
RESTORE DATABASE <dbname> WITH RECOVERY
That's for a database in the RESTORING state, not for a database in the RECOVERING state.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability