Post reply

Active-Passive Clustering

  • January 31, 2008 at 12:45 pm

    #154103

    Hi

    We have a SQL2005 up and running as standalone box. Now I need to build another box and then cluster them as Active-Passive. We need to minimize the downtime as much as possible.

    Could you please advice what is the best way and steps to do this?

    Thanks

    Utsab Chattopadhyay

  • April 2, 2008 at 9:50 am

    #797352

    What is your time window?



    My blog

  • April 2, 2008 at 10:41 am

    #797392

    I'm assuming you know something about clustering. If you don't, then you probably should hire someone (consultant) that does. Asking a general question like that concerns me. If you know something about clustering, I apologize.

    You need to be sure that your clustered hardware is on the Windows HCL. You can't just take two boxes and make them a cluster.

    Also, what problem are you trying to solve. There are other HA technologies, like mirroring, that might work better.

  • April 2, 2008 at 11:02 am

    #797410

    are you planning to use same SQL Server name?

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • April 2, 2008 at 3:32 pm

    #797532

    Gyus

    Thanks for the advices and I am sorry for late reply.

    I actually completed this clustering now. I found no way to directly upgrade standalone instance to clustered one. However, I installed a new named instance and migrated existing DB to the new clustered one before shutting down the standalone instance.

    If anyone have any better idea, please share.


    CDBA

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

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