Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CHECKDB Expand / Collapse
Author
Message
Posted Tuesday, September 21, 2010 3:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
Dear All,

Can you please confirm whether it's fine to schedule/run the CHECK DB on production databases on weekly basis on non peak hours? or is there any impact?

Thanks and Regards,
Ravichandra.
Post #990066
Posted Tuesday, September 21, 2010 3:31 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:15 PM
Points: 43,017, Visits: 36,179
You need to run it, and in non-peak hours is the best time.

Is weekly enough? Well, depends on how long you retain backups. Ideally you should be running CheckDB often enough that should it find corruption restoring from a clean backup without data loss is always an option. So if you only retain 2 days of backups, you ideally want to be running checkDB once every 2 days at minimum.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #990078
Posted Tuesday, September 21, 2010 4:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743

Dear Gail Shaw,

Thanks.

Full backups are running on Weekend i.e, Sunday.
Iam planning to schedule /run it (CHECKDB) on Saturday.

Is it fine to run update statistics( sp_updatestats) after CHECKDB?please

I have one more doubt, Will statistics update automatically when index rebuilt done?

Thanks and Regards,
Ravichandra.
Post #990100
Posted Thursday, September 23, 2010 2:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
Dear All,

can someone please advise on the below?

Thanks and Regards,
Ravichandra.

Post #991819
Posted Thursday, September 23, 2010 6:13 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 8, 2014 8:17 AM
Points: 5,991, Visits: 12,939
ravisamigo (9/21/2010)

Dear Gail Shaw,

Thanks.

Full backups are running on Weekend i.e, Sunday.
Iam planning to schedule /run it (CHECKDB) on Saturday.

Is it fine to run update statistics( sp_updatestats) after CHECKDB?please


yes

have one more doubt, Will statistics update automatically when index rebuilt done?



dbcc dbreindex yes, dbcc indexdefrag, no


---------------------------------------------------------------------

Post #991931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse