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.
2. Go to the Object Explorer window. Select your database and then click on “New Query“:
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)
4. Click on “Execute” to run the Query:
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