• If the database state is RECOVERING, then it is running the recovery process and will come online at the end of that. Probably there's a large transaction that needs to be rolled back, or lots of committed transactions whose changes hadn't been written to the data file.

    For those of us who don't memorise operating system errors, what is error 1450?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass