I'm a junior DBA and I have a very strange problem with one database.
Today, after a power failure, one database (with Recovery: full) show (In recovery) in SSMS ie: myDatabase (In recovery) (database status: recovery, Shutdown)
After finish, the "recovery process" the database shows the name myDatabase without "(In recovery)". I thought that the problem was solved, but it was not.
When I started the application that uses that database, the legend "(In recovery)" appears again next to the name of my database.
I waited until the "recovery process" finished and then I took the database offline and bring it back to online.
I restarted the server, restarted the computer and when my application was running the legend appears again. In the SQL Server logs the message "Starting up database 'myDatabase'" appears few times. It seems that the database is working because I can insert data, but the state is showing that something it happens.
PLEASE HELP !!!
thanks in advance
Edit: When I ran this query:
SELECT databasepropertyex('nyDatabase', 'STATUS') it
shows Recovering, online, suspect and the back to online and then Recovering and so on.
-- UPDATE --
I found the problem and the property AutoClose was "True" (AutoClose=True). The solution is to set AutoClose = False.
Thanks to everyone