Servers

    SQL Server 2008 Upgrade Technical Reference Guide

    Language:
    English
    This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
    • Version:

      1.0

      File Name:

      SQL2008UpgradeTechnicalReferenceGuide.docx

      Date Published:

      11/25/2008

      File Size:

      7.0 MB

        A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote plan sufficiently for the upgrade, and match the complexity of your database application. Otherwise, you risk costly and stressful errors and upgrade problems. Like all IT projects, planning for every contingency and then testing your plan gives you confidence that you will succeed. But if you ignore the planning process, you increase the chances of running into difficulties that can derail and delay your upgrade. This document covers the essential phases and steps involved in upgrading existing SQL Server 2000 and 2005 instances to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks.
        • Chapter 1 gives an overview of the technical issues and decisions that are involved in an upgrade to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.
        • Chapter 2 addresses issues related to upgrading to SQL Server 2008 Management Tools.
        • Chapters 3 through 8 focus on upgrade issues for SQL Server relational databases.
        • Chapter 9 addresses upgrading to SQL Server 2008 Express.
        • Chapters 10 through 14 focus on upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.
        • Chapter 15 addresses the implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.
        • Appendix 1 contains a table of allowed SQL Server 2008 version and edition upgrade paths.
        • Appendix 2 contains an upgrade planning checklist.
    • Supported Operating System

      Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista Service Pack 1, Windows XP Service Pack 3

        • Microsoft Word 2007
      • Click the Download button on this page to download the Word document to a folder on your computer.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

       Download a free trial of SQL Server 2014.
    SQL Server 2014
    Faster transactions, faster queries, and faster insights.
    Free trial