Migrate from SQL Server 2000 Cluster to SQL Server 2005 cluster

Question

Post reply

Migrate from SQL Server 2000 Cluster to SQL Server 2005 cluster

sri hari satish

Newbie

Points: 3
More actions
May 30, 2008 at 9:48 am

#191828

Friends -

Any one could provide me detail steps in migrating SQL Server 2000 cluster to SQL Server 2005 Cluster.

Our existing enviornment is SQL Server 2000 SP4 cluster (active/active).

we are planning to migrate to SQL Server 20005 Sp2 cluster (active/Passive).

Question : 2

Is it possible to backup non-cluster user database and restore to cluster user database in sql server 2005.

Question : 3

Detailed steps how to migrate DTS Packages to SSIS.

Question : 4

Steps to Failover clustering in SQL Server 2005

Appreciate your support

Cheers 🙂

Satish

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

This is a big enough topic that I don't think a post here is going to help much. What I'd do, were I you, is dig into the subject on MSDN and Books Online. There are good articles there on setting up clustered servers, migrating databases, migrating DTS packages, etc. But they are way outside the scope of a forum reply.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Johan Bijnens SSC Guru Points: 134873 More actions · Answer 2

Just to add to the previous post...

First of all it is a good thing you plan to migrate in stead of upgrade.

- whatever you do, start with SQLServer 2005 upgrade advisor. It checks your sql2000 instance and points to known issues you may need to fix before migrating.

- keep in mind MS did disable stuff to your advantage.

Only open it if you don't have a valid alternative.

- try to adapt to the "new" security philosophy.

- Is this your first sql2005 ? your biggest issue will be finding your way around in the new interface (SSMS) and the separation with BI dev studio.

- SSIS (dts replacement) is something completely new. BI-dev studio is a complete dev-environment by itself ! Not as intuitive as DTS, but way more controlable and manageble.

- prepare, prepare, prepare and take the time it needs !