Post reply

update sp4 on sql server 2000 cluster

  • September 23, 2009 at 5:15 am

    #226475

    I have sql server 2000 cluster and I want to update sp4 on it but currently 2nd node is down so can still I update it and can I work paralleled,means can user do their work also at same time of updation.

    Thanks

  • September 23, 2009 at 5:28 am

    #1057412

    guptaajay1985 (9/23/2009)

    I have sql server 2000 cluster and I want to update sp4 on it but currently 2nd node is down so can still I update it and can I work paralleled,means can user do their work also at same time of updation.

    Yes, you can install SP4 but your users will be interrupted not because of second node is down but due to SP4 installation.

    so far as I can recall, SP4 required a reboot. So have it calculated.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • September 23, 2009 at 5:41 am

    #1057416

    you have written very confusing please clear it

    Thanks

  • September 23, 2009 at 5:49 am

    #1057420

    guptaajay1985 (9/23/2009)

    you have written very confusing please clear it

    Okay, Let me put it this way.

    While your second node is down, you can still install SP4 and once your second node is up you can verify it there as well.

    There will be interruption in user's connection during the SP4 installation as it will ask you to stop the MSSQL services else show you the message that files are locked.

    after the installation of SP4, it will ask you for a server reboot (if it has found any locked files during the installation)

    Let me know if I am clear enough.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply