Post reply

DB in Inrecovery Mode

  • November 2, 2007 at 6:34 am

    #118709

    Hi,

    one of my DB is showing as "In recovery". Now i want to bring into back as an working mode(recovery mode).

    any one can help me. in this issue.

    Note : i don't have backup file

    Regards,

    Kishore KK.

  • November 2, 2007 at 7:08 am

    #747725

    you can use either of the below two options to get the database into recovery state

    RESTORE DATABASE database_name

    WITH NORECOVERY

    OR

    RESTORE LOG database_name

    WITH NORECOVERY

  • November 2, 2007 at 7:13 am

    #747730

    did it go to the in recovery state after a service restart if so then your database is in recovery statte and ytou have to wait until it completes. this might have been caused if you have ran a huge transaction and aborting it in middle.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • November 2, 2007 at 7:38 am

    #747739

    sorry, its recovery instead of no recovery

    -------------------------------------

    you can use either of the below two options to get the database into recovery state

    RESTORE DATABASE database_name

    WITH RECOVERY

    OR

    RESTORE LOG database_name

    WITH RECOVERY

Viewing 4 posts - 1 through 3 (of 3 total)

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