<div>
Are you running UPDATES STATISTICS daily?<br />
When do you run Reindexes or Rebuilds?
</div>


Are you running UPDATES STATISTICS daily?
When do you run Reindexes or Rebuilds?

<div>
it is part of maintenance plan:<br />
<br />
The below are the steps covered: (these are run every night together).<br />
<br />
Backup<br />
Compress backup<br />
Delete Old Backup file<br />
Database Integrity<br />
Rebuild<br />
Reindex<br />
Update Stats<br />
History Cleanup
</div>


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

<div>
<div class="content wysiwyg-content">
in the nightly maintenance job, the update statistics failed.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;specifically on one table.. and Error: 5242 was reported.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;this is the second time the same error has happened as part of the UPDATE STATISITICS step in one week (it runs every night).<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;i ran the update statistics now manually on both tables and they worked fine:<br />
(syntax: UPDATE STATISTICS &lt;tablename&gt; WITH FULLSCAN) )<br />
<br />
running DBCC checkdb now returns no error.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href="http://www.sqlskills.com/blogs/paul/corruption-errors-msg-5242-level-22/" rel="ugc">http://www.sqlskills.com/blogs/paul/corruption-errors-msg-5242-level-22/</a> suggests it is surely data corruption.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if it is, why would they work now fine, when run manually?
</div>
</div>


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?

occational updateStats failing.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.