Post reply

What does this message in Error Log means?

  • July 17, 2009 at 2:31 am

    #212453

    Hi All,

    In one of servers, following message is logged:

    "Analysis of database 'X' (14) is 100% complete (approximately 0 more seconds)."

    Please help in understanding it better.

  • July 17, 2009 at 2:42 am

    #1026062

    Hi All,

    FYI..

    SQL SERVER 2000 EE with SP4 is installed on server.

    This database is of size 9.7 GB and with log file of size 2.8 GB.

    This message was logged when server was restarted. The Database X looks like to be working fine. But on searching about it on net, this message is linked to Suspect db. Does it show this db is having some problem? Please suggest.

  • July 17, 2009 at 3:12 am

    #1026066

    Hi,

    This is just SQL checking the db at start up for transactions that need rolling back or forward etc. It should do this for each db on the instance. If you are unsure about the integrity of your db then run a dbcc CHECKDB command against the database (this check should be run regularly).

    Hope this makes sense.

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • July 17, 2009 at 4:18 am

    #1026075

    Thanks Mr T-SQL for the response.

    I will definitely run DBCC CHECKDB and check the integrity of this database at night.

    Bye,

    Ankur

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

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