Home Forums SQL Server 2008 SQL Server 2008 - General Is DBCC CHECKDB an appropriate weekly check for a 365x24x7 availability db? RE: Is DBCC CHECKDB an appropriate weekly check for a 365x24x7 availability db?

  • March 25, 2013 at 5:29 am

    #1600240

    Whats your RTO and RPO for the database? If its mission critical and DBCC CHECKDB only takes 1 - 2.5 minutes to run, I would run it every day not weekly. The only impact to the users would be while the snapshot is being created that DBCC CHECKDB runs on, so will be very minimal.