Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: how to take MS sql2000 offline

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    how to take MS sql2000 offline

    Hi all,
    I got a small part time of job for mentain the on line database , which I developer, before. Now, we need to update MS sql 2000 package 1 to database Sql 2000 SP4.
    I read the ducument , it recomend take database offline before you apply SP4, is that means shout down the connection to the users??
    Thank you!
    ________
    Honda Nh Series History
    Last edited by sql; 03-06-2011 at 01:53 AM.

  2. #2
    Join Date
    Sep 2002
    Posts
    169
    When applying a service pack, you should stop all of your users/applications from using any of the databases.

    Ideally, this would be done by arrangement with your users.

    Make sure you backup all databases prior to applying the service pack. Changes are made to system databases and possibly user databases. If something goes wrong, your only option will be to restore the databases using a backup taken prior to the service pack.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    And don't have to take every db offline.

  4. #4
    Join Date
    Jul 2003
    Posts
    421

    update sql

    How should I know My SQl sqever package one is 23 bit or 64 bite?
    ________
    M112 ENGINE
    Last edited by sql; 03-06-2011 at 01:53 AM.

  5. #5
    Join Date
    Feb 2003
    Posts
    1,048
    Oy!! Read the directions that come with the SP4 package before upgrading it. There is too much information that you need to know first.

    However, to answer your specific question, you don't need to take the databases offline, you need to stop the SQL Service completely. In fact, you need to stop all non-critical services on the server including IIS, anti-virus, etc.

    SP4 is a major service pack upgrade and should not be done until you are sure of the steps you need to follow.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    You can find out with 'select @@version'.

  7. #7
    Join Date
    Feb 2003
    Posts
    1,048
    @@Version does not report that your SQL Server is 32 bits on a 32 bit system. If you are on a 64 bit system, does it report that it is 64 bit?

    It would make sense if that is the case.

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    You will see (Intel IA-64) on 64-bit sql2k and (Intel X86) on 32-bit sql2k.

  9. #9
    Join Date
    Feb 2003
    Posts
    1,048
    But you can have a 32 bit SQL Server running on 64 bit Windows. Isn't this more a report of the processor type rather than the SQL Server type?

    I'm not trying to be argumentative. I'm asking because I actually don't know.

  10. #10
    Join Date
    Jul 2003
    Posts
    421
    Hi all.
    Thank you for the reply, as my guess is 32 system.
    I got Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
    if I forget the SQl admin password , wha tcan I do?

  11. #11
    Join Date
    Jul 2003
    Posts
    421
    Hi all,
    now I got , did I successful update?
    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 1)

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    Rawhide, @@version reports SQL Server type. You'll get (Intel X86) even run 32-bit sql on 64-bit box.

    sql, you did successful update.

  13. #13
    Join Date
    Jul 2003
    Posts
    421
    Hi all,
    The pupose for this update is they want to update the whole Web application to Win server 2003. they want a real server. How can I update, we have MS sql server package 1 stand edition on hand. but if I can't install SQl package 1 on Win server 2003, how can I update it. the machine still on the road, but be order, any advice?
    thank you
    ________
    Iphone games
    Last edited by sql; 03-06-2011 at 01:54 AM.

  14. #14
    Join Date
    Feb 2003
    Posts
    1,048
    Thanks, rmiao!!

    sql, I don't understand the problem. Why can't you update it?

  15. #15
    Join Date
    Jul 2003
    Posts
    421
    Hi , I think I update on wind XP , but the organization in here want to move the whole system from Windows XP to MS server 2003. I can't install MS sql 2000 package 1 into mS server 2003 right? if not sql server in there, how can I update?
    any ideal??
    Thank you
    ________
    Buy Marijuana Seeds
    Last edited by sql; 03-06-2011 at 01:54 AM.

Posting Permissions

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