Replace hardware with other architecture (IA64 -> X64)

#1

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#2

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#3

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#4

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#5

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#6

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#7

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#8

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#9

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

#10

Hi again!

I suppose since there is no response no one has done this from IA64 to
X64. Anyone done it from X86 to X64 or vice versa? If so, any
experience to share?

I have decided to export my logins from master and jobs from msdb so I
can import it in the new instance. Then I'll attach the user
databases.

/Peter

On Tue, 15 Apr 2008 17:42:02 GMT, peter.lindbergTAKE (AT) AWAYmartinsson (DOT) se
(Peter Lindberg) wrotc:

Quote:

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance
running on W2K3 SP2 ia64.

We are going to replace the hardware and the new will be running W2K3
SP2 x64.

Clustername, DTC name and the host names will be new.
I will keep the virtual server name and IP address for the sql
instance.

I will also install SQL2K5 x64 with the same paths as I had on ia64.

My question is if I will be able to reuse master and msdb databases?
That's because I'll have to script a lot of logins and jobs otherwise,
and that means longer downtime for the system.

I've done this scenario when changing hardware with the same
architecture, but here it's as said from intel itanium to intel x64.

/Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Replace hardware with other architecture (IA64 -> X64)

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Replace hardware with other architecture (IA64 -> X64) - 04-15-2008 , 12:42 PM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM

Re: Replace hardware with other architecture (IA64 -> X64) - 05-08-2008 , 08:53 AM