Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

DBCC CHECKDB

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
pma111
Asked:
pma111
3 Solutions
 
pcelbaCommented:
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
 
NARANTHIRANCommented:
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
 
pma111Author Commented:
What exactly causes the corruption and how common is it.

What is the overall risk of corruption to your data?
0
 
alanccwCommented:
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
 
pcelbaCommented:
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now