Back in June of last year, I talked about Microsoft SQL Server 2008 Upgrade Advisor and how it can help in identifying potential upgrade issues when moving from earlier versions of SQL Server – see Microsoft SQL Server 2008 Upgrade Advisor . Bottom line, upgrading your database server requires careful planning. If you are still in the process of considering upgrading to SQL Server 2008 and are trying to workout whether to do an In-Place Upgrade versus a Side-by-Side Upgrade, then you will want to read Arshad Ali ‘s article on the subject over at SQL Server Central.

Follow this link:
Upgrade Strategies for Microsoft SQL Server 2008