Post reply

DBCC Checks.. will they bring the Database down?

  • March 4, 2009 at 2:34 am

    #128236

    Hi All

    I have a very simple question

    I want to run some DBCC checks on a Database in SqlServer 2000

    This is on a live system and we usually run them at night.

    will the dbcc checks bring the database down?

    Cheers

    G.

  • March 4, 2009 at 2:53 am

    #952963

    Hi,

    DBCC will not bring down the DB but it will block access... If your Databases are heavily utilized then it may created blocks!

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • March 4, 2009 at 2:54 am

    #952965

    Thank you for your reply

    I believe it will be ok to run.

    Cheers

    G.

  • March 4, 2009 at 6:25 am

    #953081

    graham.boyle (3/4/2009)

    I want to run some DBCC checks on a Database in SqlServer 2000

    What DBCC checks? There are a lot of DBCC commands. Which one in particular are you talking about?

    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

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

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