SQL 2000 Database restore to Sql 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2000 Database restore to Sql 2005

Hi all, When restoring an SQL 2000 Database to SQL 2005, The compatibility level is set to sql 2000. Does this option has any implication on the performance of the server. Given that SQL 2005 is supposed to have better performance? Thanks AKTHAR
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=673499&SiteID=1 neares information fyi.
As of the performance i don’t think this will be affected, but make sure the clients are not having such degrade of performance when connected using necessary protocols to SQL. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thanks for the link AKTHAR