I have recently read an article that suggests "torn page detection" should be on. However, on our system it is not and I cannot find any guidance on Baan Support or Baanboard to tell me why not to turn it on for our database.
The article is below:
http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1088405,00.html

Thanks

Ed

hi Edhubbard

Because data pages in SQL Server (8K) and NT Server or Windows Server (512 bytes) are different sizes, it is possible during power failures, or if you are have disk driver or physical disk problems, for your database to become corrupted.

As you can imagine, this corrupts the data page, and in effect makes your entire database corrupt. There is no way to fix a database made corrupt due to a torn page, except by restoring a known good backup. One of the best ways to prevent this problem is to ensure your server has battery backup. But this does not prevent all problems, because a defective disk driver can also cause similar problems.




Viplov