Course 5336: Performing a Side-by-Side Upgrade of a Microsoft SQL Server 2000 Relational Database Environment to Microsoft SQL Server 2005

Introduction In this two-hour online course, you will learn how to perfom a Side-By-Side upgrade of a SQL Server 2000 database. Topics covered include migrating databases using the Backup and Restore method as well as migrating databases using the Copy Database Wizard. These courses are for database administrators that are responsible for installing SQL Server 2005 within environments that have existing SQL Server 2000 installations.

Student prerequisites:

This course requires that students meet the following prerequisites:

• Have thorough experience with SQL Server 2000 including the knowledge and skills to manage and maintain a SQL Server 2000 database solution.
• Be familiar with SQL Server 2005 features, tools, and technologies and have a comprehensive understanding of all its new features and technologies including:
• • The relational engine
  • Storage engine
  • Integration Services
  • Analysis Services
  • Reporting Services

Objectives At the end of the course, students will be able to:

• Perform a side-by-side upgrade of a SQL Server 2000 relational database environment to SQL Server 2005.
• Migrate databases from a SQL Server 2000 relational database environment to SQL Server 2005 by using the Backup and Restore method.
• Migrate databases from a SQL Server 2000 relational database environment to SQL Server 2005 by using the Copy Database Wizard.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Performing a Side-by-Side Upgrade of a SQL Server 2000 Relational Database Environment to SQL Server 2005 Module Introduction Performing a Side-by-Side Upgrade Lesson Introduction Introduction to the Side-by-Side Upgrade Method Pre-Upgrade Planning for a Side-by-Side Upgrade How to Perform a Side-by-Side Upgrade Methods for Database Migration Common Database Migration Issues and Solutions Methods to Re-Point Applications at the New SQL Server 2005 Instance Self Test Migrating Databases by Using the Backup and Restore Method Lesson Introduction Considerations for Using the Backup and Restore Method Pre-Migration Tasks How to Back Up a SQL Server 2000 Relational Database How to Restore a SQL Server 2000 Relational Database Post-Migration Tasks Methods to Troubleshoot Migration Issues Self Test Migrating Databases by Using the Copy Database Wizard Lesson Introduction Considerations for Using the Copy Database Wizard Pre-Migration Tasks How to Migrate a Database by Using the Copy Database Wizard Post-Migration Tasks Methods to Troubleshoot Migration Issues Determining the Migration Method for a Given Scenario Self Test Lab A: Migrating a SQL Server 2000 Relational Database by Using the Backup and Restore Method Lesson Introduction Scenario Exercise Information Launch the Lab Lab Review Lab B: Migrating a SQL Server 2000 Relational Database by Using the Copy Database Wizard Lesson Introduction Scenario Exercise Information Launch the Lab Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled