Solved

occational updateStats failing.

Posted on 2014-10-22
3
114 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Expert Comment

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

Author Comment

by:25112
ID: 40403379
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 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40403818
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

696 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