Solved

occational updateStats failing.

Posted on 2014-10-22
3
111 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 48

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 48

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

828 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