Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Set standard database options Expand / Collapse
Author
Message
Posted Saturday, January 12, 2008 3:03 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 2,868, Visits: 3,211
Comments posted to this topic are about the item Set standard database options

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #442155
Posted Thursday, February 7, 2008 2:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 2,868, Visits: 3,211
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #452609
Posted Thursday, February 7, 2008 11:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:54 AM
Points: 16, Visits: 230
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

Post #452862
Posted Thursday, February 7, 2008 12:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:54 AM
Points: 16, Visits: 230

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

Post #452888
Posted Friday, February 8, 2008 2:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 2,868, Visits: 3,211
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #453110
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse