Post reply

SQL 2016: Database is going to "In Recovery" model

  • October 4, 2016 at 2:35 am

    #400832

    Hello,

    We are on "Microsoft SQL Server 2016 (RTM-GDR)" and one of our DBs has been constantly going to "In Recovery" mode quite often and I don't see anything in SQL log either, this is the only message I see:

    Recovery is complete

    Recovery is writing a checkpoint in database

    1 transactions rolled back in database

    4 transactions rolled forward in database

    Any help would be greatly appreciate.

    Thanks!

  • October 4, 2016 at 3:28 am

    #1904612

    Is AutoClose enabled?

    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

  • October 4, 2016 at 3:34 am

    #1904614

    It's set to false in fact.

  • October 4, 2016 at 3:48 am

    #1904615

    For that database?

    What else is in the error log before that Recovering message?

    For a DB to be going into recovery often, it would either have autoclose enabled (and hence recovering every time someone accessed it), or some code is explicitly closing and opening the DB on a regular basis (or restoring from backup, or similar)

    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

  • November 8, 2016 at 12:05 am

    This was removed by the editor as SPAM

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

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