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 AKTHARhttp://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
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thanks for the link AKTHAR
]]>