INFO: Upsize SQL Server 2000 Desktop Engine to SQL Server

This article was previously published under Q325023
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a data engine that is built on and is based on core SQL Server technology.

For an overview of MSDE 2000, visit the following Microsoft Web site:
Because your applications may grow beyond the 2-gigabyte (GB) data limit of MSDE 2000, or the application's user base may grow beyond the work load limitation in MSDE 2000, you may have to migrate the MSDE 2000 solution to SQL Server. SQL Server can handle hundreds of concurrent users and databases that grow to sizes beyond one terabyte (TB). By migrating to SQL Server, you can fulfill scalability needs without having to make costly and time-consuming changes to existing applications.

When the time comes to migrate your MSDE 2000 to SQL Server, you have several options: For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
290623 ACC2002: How to Attach an Existing SQL Server 2000 Database to SQL Server 2000 Desktop Engine
224071 Moving SQL Server Databases to New Location with Detach/Attach
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
MSDE data engine

Article ID: 325023 - Last Review: 01/17/2015 05:46:33 - Revision: 3.9

  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbinfo KB325023