Post reply

Database is in recovery status.

  • March 24, 2010 at 2:41 am

    #156816

    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

  • March 24, 2010 at 3:10 am

    #1138748

    hi,

    any errors in errorlog?

  • March 24, 2010 at 3:32 am

    #1138756

    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/

  • March 24, 2010 at 4:03 am

    #1138768

    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."

  • March 24, 2010 at 5:57 am

    #1138814

    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

  • March 24, 2010 at 6:11 am

    #1138825

    select * from sys.databases where name = 'dbname'

    state_desc = RECOVERING

  • March 24, 2010 at 6:28 am

    #1138838

    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

  • March 24, 2010 at 6:34 am

    #1138845

    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 .....

  • March 24, 2010 at 8:58 pm

    #1139367

    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.

  • March 24, 2010 at 10:13 pm

    #1139387

    no errors in errorlog.

  • March 24, 2010 at 11:25 pm

    #1139403

    any help?

  • March 25, 2010 at 12:02 am

    #1139406

    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

  • March 25, 2010 at 12:26 am

    #1139412

    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/

  • March 25, 2010 at 12:45 am

    #1139415

    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/

  • March 25, 2010 at 12:46 am

    #1139416

    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