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

Chapter 3. Upgrading SQL Server 2008 Best Practices

Chapter 2 covers performing a new installation of SQL Server 2008. In this chapter, we discuss upgrading SQL Server from a previous version. First, we cover reasons for upgrading to SQL Server 2008. We then discuss the pros and cons of various upgrade strategies, and you learn about the various tools available to help mitigate risk during the upgrade process. We discuss SQL Server 2008 behavior changes and discontinued features that you need to know about before upgrading. To wrap up, we explain how to use the new Policy-Based Management that can be used to enable and disable features and functionality. By the end of the chapter, you will have learned everything you need to know in order to perform a successful upgrade to 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