December 11, 2008 at 11:10 am
Hello,
In SQL Server 2005, is it possible to set the "Compatibility level" to 80 but set the "Page verify" to CHECKSUM?
A customer has SQL Server 2005 with the compatibility level set to 80 and the page verify set to TORN_PAGE_DETECTION. I want to advice to check the need for the 80 level via the upgrade advisor, but if this level is necessary, I still would like to advice to change to CHECKSUM. Any thoughts?
Thanks in advance!
Patrick
December 11, 2008 at 11:47 am
My understanding is that Compatibility Level is primarily a syntax restriction, and does not have anything to do with the actual internal format of the database.
As such, if you cannot set Page Verify to Checksum in Compatibility Level 80, then I would suggest that you try switching the DB to Level 90, setting Page Verify, then switching back to Level 80. That might work. FYI, you don't want to do this while anyone is using the database...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply