InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:26:28 GMT20http://www.sqlservercentral.com/Forums/Topic990066-5-1.aspx[quote][b]ravisamigo (9/21/2010)[/b][hr]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[/quote]yes[quote] have one more doubt, Will statistics update automatically when index rebuilt done?[/quote]dbcc dbreindex yes, dbcc indexdefrag, noThu, 23 Sep 2010 06:13:00 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic990066-5-1.aspxDear All,can someone please advise on the below?Thanks and Regards,Ravichandra.Thu, 23 Sep 2010 02:50:15 GMTravisamigohttp://www.sqlservercentral.com/Forums/Topic990066-5-1.aspxDear 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?pleaseI have one more doubt, Will statistics update automatically when index rebuilt done?Thanks and Regards,Ravichandra.Tue, 21 Sep 2010 04:26:23 GMTravisamigohttp://www.sqlservercentral.com/Forums/Topic990066-5-1.aspxYou 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.Tue, 21 Sep 2010 03:31:55 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic990066-5-1.aspxDear 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.Tue, 21 Sep 2010 03:12:15 GMTravisamigo