?
Solved

occational updateStats failing.

Posted on 2014-10-22
3
Medium Priority
?
115 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 51

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 51

Accepted Solution

by:
Vitor Montalvão earned 2000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

801 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