Post reply

DBCC CHeck Dbs

  • April 23, 2022 at 7:17 pm

    #4021098

    Hi,

    We have about 30 SQL Server instances. I didn't see any DBCC Check DB jobs are scheduled. What will be the impact? How do you manage to run DBCC Check db  in very large production databases?

    Thanks,

     

  • April 24, 2022 at 8:10 pm

    #4021449

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • April 25, 2022 at 11:05 pm

    #4022139

    dbcc is there to alert you of problems when they occur, primarily corruption issues.

    If you don't run these, then they can be in your backups. Potentially if you needed to restore from a backup for any reason, you would be missing data. The reason we run DBCC is to detect this early and fix the table or replace hardware.

    Schedule these in production. That's what you need to do, which means allocating resources and time to run the checks.

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

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