Database is in recovery status.

  • 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

  • hi,

    any errors in errorlog?

  • 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/

  • This clearly mentions that Database is recovering. The recovering process is a transient state; where database will automatically become online if the recovery succeeds. In case the recovery fails, the database will become suspect. The database will not be available.

    Also you can provide more details how this kind of situation arises?

    You have to be patience.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • If you query sys.databases, what's the value for state_desc for this database? Recovering or restoring?

    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
  • select * from sys.databases where name = 'dbname'

    state_desc = RECOVERING

  • There should be entries in the SQL Server error log saying what's happening with the database and how long recovery will take. What's in the SQL error log?

    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
  • Check the size of the mdf and ldf files. also check if there is enough free space in the drive, where mdf and ldf files are located .....

  • The database is in recovery mode since 3months.so i am not able find any logs in sqlserverlog.

    There is enough space in the drive.

  • no errors in errorlog.

  • any help?

  • Hi,

    If you are sure that, there is no recovery is started from your end and if the environment is not associated with production In such case you can follow the below point to recover back to online state.

    1. Restart the SQL Services.

    2. try to detach and attach the database.

    3. execute the checkdb to find out any database related error if any

    Thanks & Regards,

    Nitin Gupta
    SQl Server (7.0,2000,2005) - Sr. DBA
    HCL Technologies, India

  • charipg (3/24/2010)


    The database is in recovery mode since 3months.so i am not able find any logs in sqlserverlog.

    There is enough space in the drive.

    Who's responsible for the server ? U.

    since 3months 😀

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • Nitin Gupta - SQL DBA (3/25/2010)


    Hi,

    If you are sure that, there is no recovery is started from your end and if the environment is not associated with production In such case you can follow the below point to recover back to online state.

    1. Restart the SQL Services.

    2. try to detach and attach the database.

    3. execute the checkdb to find out any database related error if any

    Is it true restarting sql server (or) detach and attach the db to help the database online.

    Don't do this.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • charipg (3/24/2010)


    no errors in errorlog.

    Check the system event viewer application error logs.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply