Post reply

Moving SQL 2005 Cluster with 2 Cluster Groups to standalone

  • February 21, 2012 at 7:18 am

    #265027

    We currently have a SQL 2005 active/passive Cluster with two cluster groups (I'll call them sql1 and sql2).

    We must move this to a virtual environment, and want to move from the cluster to 2 stand alone sql 2005 servers (sql1 and sql2). Has Anyone had any experience on moving a SQL Cluster with 2 groups to standalone SQL 2005 Servers?

    Or in moving a cluster with 2 nodes and 2 groups to a virtual server environment?

    We must keep impacts to applications accessing sql1 and sql2 to a minimum - the end result is that sql1 and sql2 must be identical to the current cluster groups sql1 and sql2. When we cut over to the new environment, it must be seamless for the applications.

    We have no choice, it's mandated from above and it must be done, so we're trying to determine the best way to do this with as little impact to applications using sql1 and sql2. We would prefer just migrating to new 2008 servers, but that is not an option due to Time frame and Resources available. We would like to get off of the cluster environment if we can.

    We must replicate the current environment and provide a seamless transition.

  • February 21, 2012 at 7:40 am

    #1449701

    First question I'd ask the powers that be is, why? That's quite a bit of work to migrate from a clustered instance to a standalone, depending on configuration and database requirements.

    Secondly, you cannot convert a clustered instance to a standalone instance or vice-versa. If you want to go from a clustered instance to a standalone, you must do a side by side migration to a new instance. Build out a new instance and migrate your databases to it.

    Make sure you do a LoE (level of effort) assessment and inform higher-ups that there will probably be some downtime depending on the migration method used for the databases.

    Good luck!

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • February 21, 2012 at 7:44 am

    #1449704

    We're currently in the process of building new sql 2005 servers and migrating the databases to them. From what we could determine, that was the best/only option, but I wanted to get some other opinions in case we were overlooking something.

    Thanks.

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

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