Post reply

Database in Recovery

  • August 14, 2015 at 10:17 am

    #320638

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

  • August 14, 2015 at 10:26 am

    #1820126

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

  • August 14, 2015 at 11:08 am

    #1820143

    I found the completion status.

    In the error log it states that it is 99% recovered but it is hung.

    How do I get myself out of this situation?

  • August 14, 2015 at 11:17 am

    #1820147

    I can't even Drop the 2 Test Databases that are stuck at recovery.

    How can I get rid of them?

  • August 14, 2015 at 11:22 am

    #1820151

    What is really weird is that I can Select from a Table but it is in recovery mode.

    That does not make sense?

  • August 14, 2015 at 11:24 am

    #1820152

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried that table but it did not return any results.

  • August 14, 2015 at 11:45 am

    #1820156

    Chris.Hubbard4U (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried that table but it did not return any results.

    You can force the database out of the restore mode by running RESTORE DATABASE [DBNAME] WITH RECOVERY;

    😎

  • August 14, 2015 at 11:49 am

    #1820157

    It finally recovered.:-)

  • August 14, 2015 at 12:08 pm

    #1820164

    Chris.Hubbard4U (8/14/2015)

    It finally recovered.:-)

    Good stuff and have a great weekend:-)

    😎

  • August 14, 2015 at 2:57 pm

    #1820228

    Thanks! 🙂

  • August 14, 2015 at 4:13 pm

    #1820241

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried that table but it did not return any results.

    You can force the database out of the restore mode by running RESTORE DATABASE [DBNAME] WITH RECOVERY;

    😎

    That's for when a database is in the RESTORING state due to a backup or restore run WITH NORECOVERY, not the RECOVERING state. Very different things.

    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

  • August 14, 2015 at 4:26 pm

    #1820246

    GilaMonster (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried that table but it did not return any results.

    You can force the database out of the restore mode by running RESTORE DATABASE [DBNAME] WITH RECOVERY;

    😎

    That's for when a database is in the RESTORING state due to a backup or restore run WITH NORECOVERY, not the RECOVERING state. Very different things.

    Thanks (again) Gail, somehow I misread the post, slightly embarrassing.

    😎

  • August 14, 2015 at 4:30 pm

    #1820248

    Chris.Hubbard4U (8/14/2015)

    It finally recovered.:-)

    Yup, and about all you can do with a long recovery process is wait. There are no commands which can force a database out of recovery, and restarting SQL would just make the recovery process start over from scratch.

    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

Viewing 13 posts - 1 through 12 (of 12 total)

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