dbTalk Databases Forums  

SQL Server cluster migration

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


Discuss SQL Server cluster migration in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
irene
 
Posts: n/a

Default SQL Server cluster migration - 03-27-2008 , 01:15 PM






We are running an active/active SQL Server cluster with 4 named instances of
SQL Server 2000. We run 2 instances on each cluster node. We would like to
perform an in-place migration to sql server 2005 of one of the SQL Server
instances. We don't have a "test" cluster to work with. I'm wondering what
the risk level is for the instance that we are planning to migrate in place
as well as the remaining SQL Server 2000 instances on the cluster. Are you
able to direct me to any further readings on this topic?

Reply With Quote
  #2  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM






You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #3  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #4  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #5  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #6  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #7  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #8  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #9  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
  #10  
Old   
Riccardone
 
Posts: n/a

Default Re: SQL Server cluster migration - 03-27-2008 , 03:29 PM



You may start with creation of a new sqlserver2005 cluster instance
with its own new resources.
You will then need to copy any SQLServer dependencies, such as logon
accounts. After that, you can use a log shipping solution to
syncronize the two istances. There are some alternatives like execute
a copy database or a database mirroring solution or detach/attach the
database files.
When the new istance will be sincronized and your tests on it will be
positive, you can switch to the new cluster and then reconnect
apllications.

Regards
Riccardo

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.