Post reply

How to check the Health of a database in sql server 2005

  • November 3, 2010 at 8:09 am

    #228715

    Hi, all

    How to check the Health of a database in sql server 2005 and what is 'Health' concept,

    and how to know if the transactions are committed are not, can some one explain me in brief

    thanks for looking

  • November 4, 2010 at 1:21 am

    #1246394

    harita (11/3/2010)

    Hi, all

    How to check the Health of a database in sql server 2005 and what is 'Health' concept,

    and how to know if the transactions are committed are not, can some one explain me in brief

    thanks for looking

    go googling...

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 4, 2010 at 1:50 am

    #1246397

    harita (11/3/2010)

    Hi, all

    How to check the Health of a database in sql server 2005 and what is 'Health' concept,

    and how to know if the transactions are committed are not, can some one explain me in brief

    thanks for looking

    in short...

    1. Health = various factors....integrity/availability etc...

    2. DB by default set to Auto Commit, but this would in most cases be handled by code....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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