Can SQL2005 be installed on top of SQL2000 and replace it as the default database?

• humanbacon

  Grasshopper

  Points: 11

  More actions

  August 15, 2008 at 8:49 am

  #382256

  Can SQL2005 be installed on top of SQL2000 and replace it as the default database?

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 15, 2008 at 9:08 am

  #858806

  No.

  You can upgrade 2000 (not my favorite thing) and then it replaces the instance.

  You can uninstall 2000 after detaching the databases and install 2005.

  You can install alongside as a new instance.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!