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
[quoted text, click to view] "Geoff N. Hiten" wrote:
> 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.
>
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Cqlboy" <Cqlboy@discussions.microsoft.com> wrote in message
> news:7781B64F-5AFE-4073-9CF5-0C32BDDF9576@microsoft.com...
> >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
>
>
With a four hour window, you should be OK. Sounds like you are planning
everything carefully, which is the key to success.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
..
[quoted text, click to view] "Cqlboy" <Cqlboy@discussions.microsoft.com> wrote in message
news:284F05E3-12C7-4FF7-80EF-6D1CF53D4B27@microsoft.com...
> 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
>
> "Geoff N. Hiten" wrote:
>
>> 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.
>>
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Cqlboy" <Cqlboy@discussions.microsoft.com> wrote in message
>> news:7781B64F-5AFE-4073-9CF5-0C32BDDF9576@microsoft.com...
>> >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
>>
>>
>>
