Some of the people that work with me on the company convert a database from SQL Server 2000 to SQL Server 2005 without even changing the compatibility level.
They do not convert anything....
They just do backup on SQL Server 2000 and restore the database on SQL Server 2005.
I always change the compatibility level to 90 and change the error detection from torn page detection to CheckSum, then i reindex the database and update the statistics.
I would like to tell them why is good for them to change the database compatibily level to 90, but i am not choore. I know that if the database is in compatibility level 80 it works in backword compatibility level, but that affects the performance of the database? or can cause any damage?
I know that only with ctb level set to 90 you can access some features of SQL Server 2005.
But does 80 affect performance in 2005? or can it cause any problem?