Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: can i keep sql server 2000 if upgrade win 2000 to win 2003 (was "sql server 2000")

    Hello, i have a question that the sql server 2000 is install in window 2000 server. If i want to update to window 2003. Is that any problem in sql server 2000. I am worry about whether we will have problem after update. What i need to do? Many thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Updating operating systems is a bit dodgy. You might want to back everything up, do a fresh install, and restore all the backups.

    If you have to do the update, then SQL Server 2000 >SHOULD< run, so long as you have SQL SP3 installed.

    Keep in mind, though, you should check with Microsoft before you do this to your really-important-finance database server. Opinions are not guarantees.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Opinions are not guarantees.
    --But, I would lay money down on this one. [] If this server is important, I wouldn't even consider upgrading the OS. Backup the files, format the drive, install 2003, install SQL Server, restore the databases.

    It takes more time. It's safer. If this is a production server, that's the route I would take.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Oct 2003
    Posts
    232
    i taught that when u upgrade it wipes out the application and writes a new operating system


    better back up
    bigfoots

  5. #5
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    taught or thought??
    .......nevermind
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  6. #6
    Join Date
    Oct 2003
    Posts
    232
    does it matter ! think like a good thought !! haa
    bigfoots

Posting Permissions

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