HOWTO Upgrade MSSQL 7.0 Desktop to MSSQL 7.0 Standard Edition

• Trea Johnson

  Grasshopper

  Points: 11

  More actions

  June 10, 2004 at 10:29 am

  #162033

  Hey all.  Hopefully this will be an easy one.  I have an installation of MSSQL 7.0 Desktop on WinNT4.0sp6 that desperately needs to be upgraded to MSSQL 7.0 Standard Edition.  The Query Governor intentionally degrades performance if more than 5 users are active in the instance and our developers have as many as 54 connections at a time against their test and now training databases. 

  What I need to know is the proper path for upgrading Desktop 7.0 to Standard 7.0.  Microsoft's website no longer has the 7.0 steps posted, just the 2000 ones.  Specifically I was wondering if there are any pre-upgrade steps to be made, say in the registry, etc, along with a brief overview of the process.  Does the MSSQL installer handle the upgrade automatically like it does from 7.0 to 2000? 

  Any help would be greatly appreciated.  I have several developers along with their boss calling me every hour complaining about how slow the server is.

  Thanks in Advance!

  Trea

• JR-104739

  SSC Veteran

  Points: 295

  More actions

  June 10, 2004 at 4:41 pm

  #509978

  Well, i guess the best way is bakcup , restore . because is less complicated for me.

  I don't remeber documents where is described setps to perform the migration...

  JR