Solved

occational updateStats failing.

Posted on 2014-10-22
3
112 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 49

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 49

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 eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

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…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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