Corruption Detection for SQL Databases

Application databases contain useful and crucial information. However how do you know if the data is not corrupted? How do you know if the data is recoverable in case of an error? In this article I will give you a step by step guide on how to enable data corruption detection for SQL databases.

Overview

SQL servers have a page checksum feature that detects any corrupt data in a page. This mechanism stores small bits from every sector of a page and writes a specific pattern in that place. SQL Server reads this pattern and if it is not the same one store in the page, it will show a notification error telling you that data is corrupted.

Getting Started

1. Connect to your SQL database with SQL Server Management Studio. If you don’t know how to do this, please watch this tutorial video.

connect to database sql arvixe asp tutorials windows hosting

2. Go to the Object Explorer window. Select your database and then click on “New Query“:new query arvixe tutorials sql studio

3. In the “New Query” window, enter the following code to enable database corruption:

ALTER DATABASE YourDatabase SET PAGE_VERIFY CHECKSUM;

(Where “YourDatabase” must be the name of your database)

query arvixe sql tutorials

4. Click on “Execute” to run the Query:

query run successfully arvixe hosting tutorials

5. And that’s it! Corruption Detection for SQL databases has been enabled!

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , | Posted under ASP .NET 2, ASP .NET 3.5, DotNet/Windows Hosting | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *