Migrate SQL 2000 Failover Cluster to SQL 2005 clus

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Migrate SQL 2000 Failover Cluster to SQL 2005 clus

Author

Topic

satishvsh
Starting Member

41 Posts

Posted - 2008-06-02 : 15:59:32

[b]Friends -

I am new to cluster environment.

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 2005 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

[/b]

sanjnep
Posting Yak Master

191 Posts

Posted - 2008-06-02 : 16:16:01

My suggestion is first setup cluster server for SQL Server 2005 and simply restore database objects from sql server 2000.
For migration of DTS to SSIS it is not so easy. You need to learn detail arct. of both SSIS and DTS the wizard will not work. For example you need to write script task in .net language in place of active x script. You need to replace dynamic property task by global connection ect.
Thanks
and cheers tooo

satishvsh
Starting Member

41 Posts

Posted - 2008-06-02 : 16:33:54

Thanks Sanjay for your quick reply.

1. If we restore db from SQL Server 2000 to SQL Server 2005 directly, then what is the use of upgrade databases Please correct me if i am wrong.

2. do u have any good document where we can find Mirgrating DTS to ssis.

Please advise me on this.

cheers:)
Satish

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-02 : 17:16:39

Satish,
First of all: Donot post in bigger font (We are not blind).
1)Setup cluster and install SQL 2005 clustering
2)Backup and restore database in 2005
3) Make sure DTS packages are taken care :like Active scripts (Com objects) are not supported in SSIS.
4) All logins are taken care and jobs.
5) ODBC drivers and Linked servers are setup properly.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-02 : 22:34:06

You can upgrade db in many ways, backup/restore is one of them.

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-03 : 09:31:02

As above Guru's recomondation, do the instalation of Cluster for SQL 2K5 and restore all the DB's from 2k to 2k5.
For DTS to SSIS i used third party tool "DTSxChange" for Active x script you need to implement some code in .net.

For Failover go to Cluster Administration, Select the server right Click on it move to next node.

Self Assessment:-
It is very simple. First thing you think what you need, try it to search in google. Test it, if have any issues again tryto search in Google if you could't find your answer than only ask to others.

Manoj
MCP, MCTS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources