O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.7. Summary

In this chapter, we covered the compelling reasons for upgrading to SQL Server 2008. We reviewed strategies and tools such as the SQL Server 2008 Upgrade Assistant and the SQL Server 2008 Upgrade Advisor, which can be leveraged during the upgrade. Then, we discussed the upgrade process, which includes the pre-upgrade, the actual upgrade, and the post-upgrade steps for a successful upgrade. Several deprecated features were identified, along with features whose behavior changes could also affect your upgrade. In addition, we discussed how you can leverage the new Policy-Based Management to replace the Surface Area Configuration tool functionality and reduce management time for the database administrator. Now that we have done the groundwork for a successful upgrade, let's jump into SQL Server 2008.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required