Re: Migration from SQL2000 to Cluster SQL2005 ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC54F1A0-BEE4-4492-8934-4905C80B8005@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine ... member of the NLB cluster, setup NLB on it, plug the NICs ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Once again, ARP is an RFC standard, if you are having to make static entries in unicast mode, then your network device is not in compliance. ... Windows Server 2008 Readiness Team ... I was feeling nervous about our teaming-capable adapter as I read it might be sending out heartbeats, so I disabled it AND configured the cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine when no NLB is installed, but when it is, things start going screwy. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... One server with no cluster configured - all works ok. ... When static ARP mappings are added all works ok. ... I thought that the litmus test was that the router functions fine when ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... NLB is installed, but when it is, things start going screwy. ... The servers are a couple of switches away from the router so I ... 'exterior' to the NLB cluster itself. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... ARP is defined by RFC. ... Windows Server 2008 Readiness Team ... The servers are a couple of switches away from the router so I would have thought that any duplicate MAC info. or similar would have been come irrelavent/concealed at the router. ... If you run the command 'wlbs query' and the node it is run on says it is converged with all of your nodes in the cluster, that basically says the NLB configuration is correct and the nodes are talking to each other. ...
    (microsoft.public.windows.server.clustering)