• I had this problem.

    I was concerned that if I restarted the SQL Server Service that the Database would perform a recovery.

    I checked the error log and I do not see that the Database is recoverying.

    I had this situation before and I forced it to recover.. I can't remember what i did.

    If I attempt to take the Database online. I get the following error:

    Msg 5011, Level 14, State 7, Line 2

    User does not have permission to alter database 'DW', the database does not exist, or the database is not in a state that allows access checks.

    Msg 5069, Level 16, State 1, Line 2

    ALTER DATABASE statement failed.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/