Migration from SQL2000 to Cluster SQL2005 ?

Hello Everyone,
What is the best solution for my predictament? I'm moving from a single
non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD
environment (Server B). Seamlessly as possible, how can I migrate the
databases from Server A to Server B? I would like to preserve my instance
name on Server A with the new cluster environment (Server B) if possible.
Thank you
Alex Anderson
You can't do this as an in place upgrade. You are going to have to build
the new cluster, install a SQL Server failover cluster instance, and then
move the databases. The most seamless way would be using a detach/attach or
a backup/restore. You'll have to make sure you take care of the master and
msdb databases as well.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Alex Anderson" <Alex Anderson@.discussions.microsoft.com> wrote in message
news:BC54F1A0-BEE4-4492-8934-4905C80B8005@.microsoft.com...
> Hello Everyone,
> What is the best solution for my predictament? I'm moving from a single
> non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD
> environment (Server B). Seamlessly as possible, how can I migrate the
> databases from Server A to Server B? I would like to preserve my instance
> name on Server A with the new cluster environment (Server B) if possible.
> Thank you
> Alex Anderson