SQL 2005 database setup - Recovery Page Verification question

[katekis]

In the Database Properties window under the options page in the Recovery section

What is the difference between Recovery Page Verification CHECKSUM and Recovery Page Verification TORN_PAGE_DETECTION?

I am using SQL Server 2005, all my databases on the server are set at Compatibility Level "SQL Server 2005 (90) except for one. There is one of my databases set at Compatibility Level: SQL Server 2000 (80). What does that mean?

We have been having some database connection issues on one of my database servers so I am analyzing each of the databases if something not a good setup.

I am a business analysis, and did not setup the databases, I am trying to understanding things to look for if databases not setup well.

 

[mrdenny]

The two recovery page verification options are simply to different methods of looking for database corruption.

As for the database compatibility level, different versions of SQL Server have included different commands, and some commands have changed there syntaxs and results slightly.

For example the database running in Compatibility level 80 doesn't support the CROSS JOIN statement, even though it's running on a SQL Server 2005 server. Because that statement didn't exist on SQL Server 2000 it isn't usable on a database which is in that compatibility mode.

If you are having connection issues you need to look at the configuration of the entire server, not of each database.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog