Solved

DBCC CHECKDB

Posted on 2014-07-23
5
180 Views
Last Modified: 2014-07-30
1) What are the risks in not running DBCC CHECKDB over your SQL server?

2) What exactly is it checking for? What will the ouput tell you?

3) How often should/do you run it?
0
Comment
Question by:pma111
5 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 167 total points
Comment Utility
DBCC CHECKDB is good to use periodically (let say every month) and each time the database needs some maintenance, e.g. slows down etc.

This article answers almost all your questions: http://www.sql-server-pro.com/dbcc-checkdb.html
0
 
LVL 5

Assisted Solution

by:NARANTHIRAN
NARANTHIRAN earned 167 total points
Comment Utility
1)Database might get corrupted at any time due to hardware problem or some issue.

2) It checks the logical and physical integrity of all the objects in the specified database.And output will provide you status of the database.

3)How frequently you should perform these runs depends on individual businesses and their production environments.
0
 
LVL 3

Author Comment

by:pma111
Comment Utility
What exactly causes the corruption and how common is it.

What is the overall risk of corruption to your data?
0
 
LVL 3

Assisted Solution

by:alanccw
alanccw earned 166 total points
Comment Utility
It will check the integration of the MDF database. For example, whether the checksum in the page is correct. You can refer to http://technet.microsoft.com/en-us/library/ms176064.aspx for detailed info
0
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
What exactly causes the corruption and how common is it.
The data corruption may cause bug in your (or Microsoft's) code, a virus, an attacker, or hardware failure or power failure. You may suppress each of these factors by appropriate security settings and maintenance procedures and also by your hardware conditions. To install SQL database on a standalone computer with one single disk w/o UPS means high risk.

The overall risk depends on the backup frequency primarily. DBCC can signal starting hardware problems. Even broken network card can swap certain bit values which is hard to diagnose and hard to fix in data...

etc. etc.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now