Set standard database options

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ed Vassie » Set standard database options

Set standard database options

Rate Topic

Display Mode

Topic Options

Author

Message

EdVassie

Posted Saturday, January 12, 2008 3:03 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:57 AM
Points: 2,619, Visits: 2,749

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

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

EdVassie

Posted Thursday, February 07, 2008 2:40 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:57 AM
Points: 2,619, Visits: 2,749

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

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

scoinva

Posted Thursday, February 07, 2008 11:21 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 29, 2012 7:58 AM
Points: 16, Visits: 218

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

scoinva

Posted Thursday, February 07, 2008 12:12 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 29, 2012 7:58 AM
Points: 16, Visits: 218

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

EdVassie

Posted Friday, February 08, 2008 2:19 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:57 AM
Points: 2,619, Visits: 2,749

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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 »

Permissions