strange messages in sql error log

  • I see many messages like

    [INFO] Database ID: [25]. Hardened root content for checkpoint timestamp 0x0008d06b.

    What does it means?

    It apeared when I added memory optimized filegroup

  • Run this and see if it returns anything:

    SELECT * FROM sys.dm_exec_requests where command like '% LOG%' or command like '% CHECKPOINT%' or wait_type like '% LOG%'

    Alex S
  • It returns nothing

  • alexmpd (5/13/2015)


    It returns nothing

    Good. Are you on Service Pack 1?

    Alex S
  • AlexSQLForums (5/13/2015)


    alexmpd (5/13/2015)


    It returns nothing

    Good. Are you on Service Pack 1?

    Service Pack 1 is not installed on that instance

    maybe it is the reason

    but there is another instance without Service Pack 1. But there are no such messages in error log

    I plan to install Service Pack 1

    hope it will resolve the issue

  • Resolve what? It's an informational message, not an error.

    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
  • Can become an issue if its writing many times and filling up error log for no reason.

  • SP1 for SQL Server 2014 has been pulled back and delayed.

    Alex S

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

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