Seperating Second Instance to Own Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cqlboy - 29 Mar 2006 05:46 GMT

I have a W2K3 cluster hosting a default and named instance of SQL Server. We
want to move the named instance to it's own cluster, how best can I do this?
The disks are presented to the nodes from our Dell SAN.

Thanx.

-Cqlboy

Reply to this Message

Geoff N. Hiten - 29 Mar 2006 17:08 GMT

The only way I can see to do this "in-place" is to build a new cluster,
present these disks to it, and install SQL on these disks. If you have some
extra space on the SAN, you might be able to pre-install SQL on a SAN slice
and then just attach the database files.

The best way would be to build an dntirely new cluster with new disks and
then follow the normal procedure to transfer a SQL server functions to a new
host. I typically log ship the databases and find a low activity time to
"flip over" to the new system.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I have a W2K3 cluster hosting a default and named instance of SQL Server.
>We
[quoted text clipped - 5 lines]
>
> -Cqlboy

Reply to this Message

Cqlboy - 30 Mar 2006 02:16 GMT

Yes, I was thinking along similiar lines. I was figuring on something like
this:

2nd Cluster is built with a default instance of SQL Server installed + all
service packs.

1. Detaching my db's on the target instance.
2. Take the target instance offline in ClustAdmin
3. Remove the LUNs from through the SAN
4. Present LUNs to new cluster ... and all that goes with that
5. Install second instance on new cluster using same exact name as old
instance
6. Attach db's
7. Execute scripts to restore jobs + misc ???
8. Verify

This approach will allow me to use the same instance name and prevent lots of
code from breaking.

I have a 4 hour window to take everything down and bring it back online.
Supposing something goes wrong, I can move the LUNS back and bring back
the old instance back online.

This is what I'm thinking ....

-Cqlboy

> The only way I can see to do this "in-place" is to build a new cluster,
> present these disks to it, and install SQL on these disks. If you have some
[quoted text clipped - 15 lines]
> >
> > -Cqlboy

Reply to this Message

Geoff N. Hiten - 30 Mar 2006 17:02 GMT

With a four hour window, you should be OK. Sounds like you are planning
everything carefully, which is the key to success.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

.

> Yes, I was thinking along similiar lines. I was figuring on something
> like
[quoted text clipped - 48 lines]
>> >
>> > -Cqlboy

Reply to this Message