Developing an Upgrade Strategy and Plan

The plan and strategy for an upgrade is different from the plan and strategy for a new installation. In an upgrade, you have already decided on a platform and are currently running SQL Server. You might have many large production databases and hundreds of users who depend on the databases, or you might have small development databases with a few users. In many ways, upgrading an existing SQL Server is more critical than installing a new SQL Server. The existing SQL Server contains data being used and depended on by your organization.

With your organization depending on these databases, it is easy to see why it is important to develop a plan that enables you to upgrade to the new release with the least amount ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.