Sessions: 463 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Saturday, November 23, 2024
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
          CHECKDB With Data Pu...
          Displaying a trace o...
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS




Will be added as a sub-category of, DBCC
CHECKDB With Data Purity

When upgrading from sql server 2000 to 2005, a dbcc checkdb must be run at least once with data_purity.

If an error occurs with the data_purity, these rows should be fixed.  Some fixes can be done by updating the data or by running dbcc updateuseage {table_name / index}, the error / message from checkdb will contain the table_name and/or index to run updateuseage with.