Solved

occational updateStats failing.

Posted on 2014-10-22
3
106 Views
Last Modified: 2014-10-29
in the nightly maintenance job, the update statistics failed.
           specifically on one table.. and Error: 5242 was reported.
           this is the second time the same error has happened as part of the UPDATE STATISITICS step in one week (it runs every night).
           
           i ran the update statistics now manually on both tables and they worked fine:
(syntax: UPDATE STATISTICS <tablename> WITH FULLSCAN) )

running DBCC checkdb now returns no error.
           
           http://www.sqlskills.com/blogs/paul/corruption-errors-msg-5242-level-22/ suggests it is surely data corruption.
                               
           if it is, why would they work now fine, when run manually?
0
Comment
Question by:25112
  • 2
3 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Are you running UPDATES STATISTICS daily?
When do you run Reindexes or Rebuilds?
0
 
LVL 5

Author Comment

by:25112
Comment Utility
it is part of maintenance plan:

The below are the steps covered: (these are run every night together).

Backup
Compress backup
Delete Old Backup file
Database Integrity
Rebuild
Reindex
Update Stats
History Cleanup
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
You don't need to run Rebuild, Reindex and Update Stats daily.
If you run Rebuild there's no need for Reindex and Update Stats.
And avoid the SQL Server Maintenance Plan. Try to create your own maintenance plan. There are some good scripts in the internet. I like this one from Ola Hallengren.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now