CHECKDB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » CHECKDB

CHECKDB

Rate Topic

Display Mode

Topic Options

Author

Message

ravisamigo

Posted Tuesday, September 21, 2010 3:12 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

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

GilaMonster

Posted Tuesday, September 21, 2010 3:31 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

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

ravisamigo

Posted Tuesday, September 21, 2010 4:26 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

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

ravisamigo

Posted Thursday, September 23, 2010 2:50 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Dear All,

can someone please advise on the below?

Thanks and Regards,
Ravichandra.

Post #991819

george sibbald

Posted Thursday, September 23, 2010 6:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:32 PM
Points: 5,270, Visits: 11,213

ravisamigo (9/21/2010)

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 »

Permissions