Post reply

In Recovery Mode

  • September 10, 2007 at 12:34 am

    #174629

    Hello,

    I have a SQL Server 2005 Enterprise Edition and a big database. My database has been "In recovery mode" status after a big delete operation. My disk size is not enough to finishing recovery.

    How to cancel or disable In Recovery Mode.

  • September 10, 2007 at 7:56 am

    #732482

    I don't think you can do this. The database needs to finish recovering.

    Do you know if it's in roll forward or roll back? Check the error log.

  • September 11, 2007 at 3:18 am

    #732710

    I found this message in ErrorLog file.

    "2007-09-10 09:05:34.76 spid14s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.

    2007-09-10 09:05:34.84 spid4s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required."

    Database Recovery Process is continuing to work still and its percentage is %32 for 21 hours. My disk size seems constant at this operations. Is this status normal?

    Thanks for your help.

  • September 12, 2007 at 8:53 pm

    #733355

    No , something seems wrong. I think you might need to call MS on this one.

  • June 19, 2008 at 4:10 am

    #830972

    i want to take database back on hardware failure on a date base.

  • October 22, 2008 at 8:08 pm

    #888440

    You can stop the service and then delete the database files if you're not worried about losing any changes. You can then restore a backup over the top.

  • November 12, 2008 at 1:19 am

    #897376

    Could you delete the database files after stopping the service??

    Please let me know.

    Even I am facing a problem.

    I stopped SQL Server service when all the disk space was consumed by tempdb and log file by a query.

    When I restarted the service the DB was in recovery mode.

    I want to delete the DB.

    Can any one help me on this???

  • December 1, 2008 at 3:15 am

    #905428

    Yes !

    You can delete the DB files if you have stopped the main DB service.

    Just delete the files or place it over some other server for analysis purpose and restore the database from a backup with the same name.

    Use the original files to analyze any changes and further processing.

    its better to get it completed by sql server auto recorvery. it will take time but will recover your database. (In Recovery).

    Regards,

    Musab

    Musab
    http://www.sqlhelpline.com

  • December 1, 2008 at 3:23 am

    #905432

    Thank you so much.

    It has worked.

  • December 1, 2008 at 3:30 am

    #905438

    My Pleasure !

    Musab
    http://www.sqlhelpline.com

Viewing 10 posts - 1 through 9 (of 9 total)

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