A common request from customers is for information about upgrading from SQL Server 2000/2005 to SQL Server 2008.

In conjunction with Solid Quality Mentors, Microsoft has published a great technical reference guide covering most upgrade scenarios. At almost 500 pages you better hope it does :).

Following is the link to the whitepaper:

 

http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

 

This should be read in conjunction with the Books online guidance on this subject:

 

http://msdn.microsoft.com/en-us/library/ms144267.aspx