Upgrading to Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali": A Comprehensive Look

This session was not that useful because our past history has been to do new or side-by-side installations and not upgrade. If we go to "Denali" we would do a separate install and rebuild the databases or create new ones for new apps.

It is good thing that we are getting new servers because we would have had to reinstall the clustering software. This was taken care of with Window 2008 and our new software installations. We avoided a lot of work to upgrade because we are working with new servers and we have a practice of creating new instances when we install the next version of SQL Server.

Types of installations:
Standalone
Clustered
Log shipping
Replication

There is copy database wizard. We would most likely use our scripts we have saved and then copy data.

Location:TechEd 2011