<div>
you can also do it through the GUI if you prefer, <br />
Right click on the database --&gt; Go to Properties --&gt; Select Options<br />
Go down to Recovery --&gt; Page Verify &nbsp; &nbsp; &nbsp; &nbsp;and select whichever you want<br />

</div>


you can also do it through the GUI if you prefer,
Right click on the database --> Go to Properties --> Select Options
Go down to Recovery --> Page Verify        and select whichever you want


<div>
so there is nothing to be concerned about that option/setting?<br />
<br />
what is the disadvantage if it is still operating in that mode?
</div>


so there is nothing to be concerned about that option/setting?

what is the disadvantage if it is still operating in that mode?

<div>
there is a very small difference between torn page detection and checksum. The only one that I can really think of is that torn page detection does not detect corruption within sectors. Checksum uses a very very small amount more CPU, but the benefits are worth that little bit.<br />
&nbsp;<br />

</div>


there is a very small difference between torn page detection and checksum. The only one that I can really think of is that torn page detection does not detect corruption within sectors. Checksum uses a very very small amount more CPU, but the benefits are worth that little bit.
 


<div>
OK. Thanks.<br />
<br />
ALTER DATABASE SomeDB SET TORN_PAGE_DETECTION OFF <br />
puts the DB to 'NONE'. How would you bring it to CHECKSUM?
</div>


OK. Thanks.

ALTER DATABASE SomeDB SET TORN_PAGE_DETECTION OFF
puts the DB to 'NONE'. How would you bring it to CHECKSUM?

<div>
<div class="content wysiwyg-content">
if one of the database says 'TORN_PAGE_DETECTION', is it of concern? what could be done to make it CHECKSUM again?<br />
<br />
thanks
</div>
</div>


if one of the database says 'TORN_PAGE_DETECTION', is it of concern? what could be done to make it CHECKSUM again?

thanks

TORN_PAGE_DETECTION

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.