May 30, 2008 at 9:48 am
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
May 30, 2008 at 11:26 am
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
May 30, 2008 at 11:42 am
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 !
Question : 2
Is it possible to backup non-cluster user database and restore to cluster user database in sql server 2005.
A database is not aware that it is hosted on a cluster !
No problem with this.
Question : 3
Detailed steps how to migrate DTS Packages to SSIS.
In BIDS you'll find a dropdown nenu to upgrade (to best effort !)
You will still need to test it fully !
Question : 4
Steps to Failover clustering in SQL Server 2005
equal to sql2000. Check out BOL!
BOL has very good info.
Make sure you have the latest version of it !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 30, 2008 at 12:30 pm
Check the following links....
http://www.sql-server-performance.com/articles/clustering/upgrade_current_cluster_p1.aspx
http://sql-server-performance.com/Community/forums/p/25061/139282.aspx
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply