Post reply

Database goes into "In Recovery" due to drive full

  • September 4, 2014 at 7:06 pm

    #1743371

    I concluded Rollback failure from these log entries.

    Error log

    During undoing of a logged operation in database '', an error occurred at log record ID (xx)

    Database was shutdown due to error 9002 in routine 'XdesRMReadWrite::RollbackToLsn'.

    Cheers

  • September 5, 2014 at 2:29 am

    #1743437

    AppSup_dba (9/4/2014)

    I concluded Rollback failure from these log entries.

    Error log

    During undoing of a logged operation in database '', an error occurred at log record ID (xx)

    Database was shutdown due to error 9002 in routine 'XdesRMReadWrite::RollbackToLsn'.

    And that's why I was asking for error log entries....

    So yes, the DB was restarted and hence entered the recovering state.

    Would there perhaps be any more error log entries which you haven't yet shared?

    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

  • September 5, 2014 at 5:30 am

    #1743476

    That is it... nothing more than some login failures...

    Cheers

  • September 5, 2014 at 6:51 am

    #1743501

    If the problem reoccurs, call Microsoft customer support and open a case. A rollback shouldn't fail and take the DB offline, for any reason.

    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

  • September 5, 2014 at 7:28 am

    #1743516

    point noted mam.. Thanks for your help !

    Cheers

Viewing 5 posts - 16 through 20 (of 20 total)

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