| Course Overview |
| Module Introduction |
| Navigation Overview |
| Lab Information |
| Course Information |
| Performing an In-Place Upgrade of a SQL Server 2000 Relational Database Environment to SQL Server 2005 |
| Module Introduction |
| Introduction to Upgrading to SQL Server 2005 |
| Lesson Introduction |
| SQL Server 2005 Enhancements |
| Upgrade Paths |
| Guidelines for Selecting an Upgrade Path |
| Considerations for Selecting Upgrade Methods for Different Databases |
| Self Test |
| Planning for an In-Place Upgrade |
| Lesson Introduction |
| Introduction to the In-Place Upgrade Method |
| Best Practices for an In-Place Upgrade |
| Pre-Upgrade Tasks |
| How to Perform the Pre-Upgrade Tasks |
| How to Run the Upgrade Advisor Tool |
| The Process of Rolling Back to the Previous Version |
| Self Test |
| Performing an In-Place Upgrade |
| Lesson Introduction |
| How to Perform an In-Place Upgrade |
| Common In-Place Upgrade Issues and Solutions |
| The Role of the SQL Server 2005 Surface Area Configuration Tool |
| Post-Upgrade Tasks |
| Differentiating Between Pre-Upgrade and Post-Upgrade Tasks |
| Self Test |
| Lab: Performing an In-Place Upgrade of a SQL Server 2000 Relational Database Environment to SQL Server 2005 |
| Lesson Introduction |
| Scenario |
| Exercise Information |
| Launch the Lab |
| Lab Review |
| Module Summary |
| Glossary |
| Module Introduction |