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.

Get Professional Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.