How to run data integrity test on a SQL server

Hi,

I  was asked to run a data integrity test on a particular database on of my SQL server. Please advise how to perform this (using built in tools if possible) if you have any particular suggestions. I am using SQL Server 2008 R2.

Thanks in advance.
Byas_SahaAsked:
Who is Participating?
 
Surendra NathConnect With a Mentor Technology LeadCommented:
run DBCC CHECKDB

and this article can help you better
http://technet.microsoft.com/en-us/library/ms180226.aspx
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Run the check db during off peak hours
0
All Courses

From novice to tech pro — start learning today.