Solved

How to run data integrity test on a SQL server

Posted on 2014-01-15
2
452 Views
Last Modified: 2014-01-15
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.
0
Comment
Question by:Byas_Saha
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 250 total points
ID: 39783368
run DBCC CHECKDB

and this article can help you better
http://technet.microsoft.com/en-us/library/ms180226.aspx
0
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 39783376
Run the check db during off peak hours
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 3 117
Re-appearing SQL Server Agent jobs 7 42
shrink table after huge delete 2 27
T-SQL: Need Group By to use "fuzzy logic"?? 3 11
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Copy Database Wizard 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.

713 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