2000 Standard to Enterprise

• womble

  SSC Rookie

  Points: 44

  More actions

  October 24, 2005 at 6:35 pm

  #88329

  Hi Everyone

  We are going to be shortly doing an upgrade form SQL 2000 Standard to 2000 Enterprise, at the same time we are going from Windows 2000 Server to Windows 2003 Enterprise Server.  Does anyone have any advice on the transferring of databases from Standard to Enterprise (all on the same box but different physical disks).  I was planning on just detaching the databases, re-formating the C drive and reconfiguring the server and then reattach the DB's.

  Hope you can help

• Xearo

  SSC-Addicted

  Points: 438

  More actions

  October 24, 2005 at 10:36 pm

  #599715

  Check out this article:

  http://support.microsoft.com/default.aspx?scid=KB;EN-US;224071

  It will give you steps for moving user as well system databases.