SQL Page Verification

Have you enabled page verification for your database? I have a monitoring system for SQL that is telling me I should enable this to prevent corruption of the db. This is the description:

For best practice, some form of page verification should be turned on for all production and system databases. The act of page verification incurs minimal overhead, and the benefit of helping to identify corrupt data is worth the extra overhead.

Between the time SQL Server writes a page to disk, then later reads the same page, it is possible that the data stored in the page may get corrupted due to circumstances outside the control of SQL Server. It is a rare occurrence, but when it does occur it can be devastating to a database, often requiring that the entire database be restored. While SQL Server cannot prevent corruption outside its control, it does at least have the ability to identify corrupt data. While this won't prevent or fix the problem, it can make the DBA aware of the problem so that it can be addressed as quickly as possible.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Have you enabled page verification for your database? I have a monitoring system for SQL that is telling me I should enable this to prevent corruption of the db. This is the description:

For best practice, some form of page verification should be turned on for all production and system databases. The act of page verification incurs minimal overhead, and the benefit of helping to identify corrupt data is worth the extra overhead.

Between the time SQL Server writes a page to disk, then later reads the same page, it is possible that the data stored in the page may get corrupted due to circumstances outside the control of SQL Server. It is a rare occurrence, but when it does occur it can be devastating to a database, often requiring that the entire database be restored. While SQL Server cannot prevent corruption outside its control, it does at least have the ability to identify corrupt data. While this won't prevent or fix the problem, it can make the DBA aware of the problem so that it can be addressed as quickly as possible.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!