Set standard database options

  • EdVassie

    SSC Guru

    Points: 60267

    Comments posted to this topic are about the item Set standard database options

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • EdVassie

    SSC Guru

    Points: 60267

    The spSetDBOptions script is just part of SQL Server FineBuild. FineBuild helps provide 1-click install and configuration of SQL Server 2005.

    To get the full product, go to www.codeplex.com/SQLServerFineBuild

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • scoinva

    SSC Enthusiast

    Points: 192

    Why do you set TORN_PAGE_DETECTION OFF for SQL 2005 servers?

    Is this intentional?

    SET @sqlstring = @sqlstring + ', TORN_PAGE_DETECTION OFF, PAGE_VERIFY CHECKSUM'

    Related URL to the quesiton:

    http://www.themssforum.com/SQLServer/Torn-Page-358147/

    Scott


    Kindest Regards,

    scoinva

  • scoinva

    SSC Enthusiast

    Points: 192

    I think I figured it out.

    In SQL Server 2005, there is a new option called Page_Verify. In earlier versions of SQL Server, it was known as TORN_PAGE_DETECTION.

    Please verify.

    Related URL:

    http://www.sql-server-performance.com/article_print.aspx?id=978&type=art


    Kindest Regards,

    scoinva

  • EdVassie

    SSC Guru

    Points: 60267

    The routine sets Page Verify to CHECKSUM for SQL Server 2005. This is a more thorough method of detecting possible corruption than the Torn Page detection.

    The options for Torn Page and Checksum are mutualy exclusive, so the routine explicitly turns off the old method and turns on the new and better method of checking for corruption.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script and the education.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply