Recent Articles

Easy Upgrade SQL Server 2000/2005 to SQL Server 2008

SQL Server 2008 is 100% backward compatible with SQL Server 2005. Simply take a full backup in SQL Server 2000\2005. Copy the backup files to the new server and restore from the backup. Change the compatibility level to 100.0 and run sp_updatestats. Everything should run as normal.