Post reply

health check up

  • October 12, 2008 at 10:27 pm

    #383042

    how to i perform health chekup for sql.pls give any document for me.and any one is interested ,pls tell me why to we perform health checkup .

  • October 13, 2008 at 6:02 am

    #884101

    Start reading Books Online ("BOL" is the abbreviation you'll see on Forums) and search for the DBCC command, especially CHECKDB

    Wilfred
    The best things in life are the simple things

  • October 13, 2008 at 8:25 am

    #884168

    First, this isn't really a backup question. Please post in the correct forum (moved to admin).

    Second, dbcc checkdb is a good place, but what do you mean by health check up? What do you think that means? Most databases run fine, there isn't a lot to check for. I'd regularly run integrity checks from the maintenance plans (which includes checkdb), I'd rebuild indexes once a week or so depending on load, enable torn page detection, and verify backups.

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

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