Re: Cannot start SQL 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 05:51:02 -0700

Charles

You can install diferent versions of SQL Server on the same server, however you need to install them in the right order. That is 6.5 first, then 7 and finally 2000. As you already had 2000 installed that is why you can not run 6.5. Also if you have mutiple versions of SQL Server you can only run one of them at a time. When you have mutiple versions you get the option to switch between them on your start menu.

You need to uninstall 6.5. If you really want it on the same server. After uninstall, take a backup of your 2000 master and detach all your user databases. Uninstall 2000. Install 6.5. Install 2000. Make sure 2000 is the active service and restore your master database (this is to synch user ID's and loggin's), attach your user databases and you should be up and running. You can then switch between 2000 and 6.5.

If you have some SQL jobs, you can either script them out before uninstalling 2000 or backup and recover the msdb database like the master.

Hope this helps

John

Relevant Pages

  • backup of database
    ... How frequently is recommended to take the backup of ... model, master and msdb database. ... Right now I am backing up only the user databases and transaction logs. ...
    (microsoft.public.sqlserver.server)
  • FreeBSD 8.1 on sparc64 bge BCM5704 watchdog
    ... MASTER -> BACKUP ... options SCSI_DELAY=5000 # Delay before probing SCSI ... device pty # BSD-style compatibility pseudo ttys ...
    (freebsd-current)
  • W97_W2K Save Options Tutorial?
    ... Save Auto Recover Info ... Backup Copy: When "Always create Backup copy" is turned on, ... overwrites the associated .wbk file. ... computer without explicitly Saving an open, ...
    (microsoft.public.word.docmanagement)
  • RAID5 (mdadm) array hosed after grow operation (there are two of us)
    ... but a lot of photos, yes I know the admin rule, backup backup backup, ... an additional drive the same size as the existing drives to add to the ... Now I cannot recover my LVM2 volume group, ... returns a result with "Incorrect metadata area header checksum" ...
    (Debian-User)
  • Re: RMAN output log
    ... have tried to run the ORacle suggested backup to the flash recovery ... no copy of datafile 2 found to recover ... channel oem_disk_backup: starting incremental datafile backupset ...
    (comp.databases.oracle.server)