Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 3,028, Visits: 3,687
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 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
Post #442155
Posted Thursday, February 7, 2008 2:40 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 3,028, Visits: 3,687
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 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
Post #452609
Posted Thursday, February 7, 2008 11:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 19, 2015 7:25 AM
Points: 16, Visits: 235
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: Wednesday, August 19, 2015 7:25 AM
Points: 16, Visits: 235

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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 3,028, Visits: 3,687
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 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
Post #453110
Posted Thursday, May 12, 2016 7:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:21 AM
Points: 7,841, Visits: 755
Thanks for the script and the education.
Post #1785648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse