+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Win2k and SQL2000 double upgrade in Technical; I have a question which I hope someone can answer and it is this: Has anybody done both a OS ...
  1. #1

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,920
    Thank Post
    1,193
    Thanked 1,064 Times in 755 Posts
    Rep Power
    329

    Win2k and SQL2000 double upgrade

    I have a question which I hope someone can answer and it is this:

    Has anybody done both a OS upgrade from w2kSP4 to win2k3R2SP2 and SQL 2000 standard to SQL 2005 enterprise upgrade on the same server?

    If they have could they let me know how they went about it as we have a dilemma in the fact we only have a week to sort it.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    Re: Win2k and SQL2000 double upgrade

    SIMS huh?

    I started thinking about this today...

    IMHO the best way to upgrade an OS is to blitz a machine and re-install. This will require an extended period of downtime (£££££ in overtime I suspect). It is easy enough to use Enterprise Manager to backup the database to a removable disk and even copy any user data off.

    The SIMS bit is what I need to think about a bit more.

  3. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340

    Re: Win2k and SQL2000 double upgrade

    Hi bossman,

    I did exactly that a few weeks ago. Was running Windows 2000 SP4 (member server) and SQL 2000. First thing before performing any upgrade is back up the server!

    Create a Windows 2003 SP2 slipstream disc (keeps things simple) and perform an OS upgrade. Once this is done, I recommend you run Windows Update and download post SP2 updates, including IE7 and .NET 1.1, 2.0 and 3.0. There aren't that many.

    You're then in a position to install SQL Server 2005. In my case I installed the Standard edition, then applied SP2 and Visual Studio SP1.

    SQL 2000 and SQL 2005 will happily work together on the same server, then allowing you to migrate the database from 2000 to 2005. In my case though Birmingham City Council plan to do this sometime in November when Sims is officially compatible with SQL 2005. Hope this helps.

  4. #4

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,920
    Thank Post
    1,193
    Thanked 1,064 Times in 755 Posts
    Rep Power
    329

    Re: Win2k and SQL2000 double upgrade

    @Michael: Have you had any problems with Sims post upgrade? How is sims running with the upgraded OS?

SHARE:
+ Post New Thread

Similar Threads

  1. Uninstalling SQL2000
    By Jobos in forum MIS Systems
    Replies: 8
    Last Post: 21st October 2007, 11:17 PM
  2. Double Entendres
    By marco84 in forum General Chat
    Replies: 1
    Last Post: 26th March 2007, 06:36 PM
  3. Win2K booting from Compact Flash
    By pete in forum Windows
    Replies: 9
    Last Post: 26th June 2006, 04:14 PM
  4. Win2K Server RSM Database / Veritas Backup problem
    By speckytecky in forum How do you do....it?
    Replies: 0
    Last Post: 12th June 2006, 12:44 PM
  5. Win2k Microsoft Update
    By _Bat_ in forum Windows
    Replies: 2
    Last Post: 28th May 2006, 02:14 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •