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.
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.
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.
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!