Re: migrating a SQL Cluster to new hardware

Tech-Archive recommends: Fix windows errors by optimizing your registry

Run upgrade advisor to detect upgrade issues, run checkdb on the databases
on the clusters, detach them, copy them (do not move them) to the new
cluster, attach them, run checkdb, update statistics, back them up. Migrate
all dependencies (logins, jobs, extended stored procedures, com objects and
file paths).

Check all functionality on the new cluster. Roll back if you have to by
reattaching the existing database on the old cluster.

repoint the client applications.

You might want to review all methods to do this in the
http://download.microsoft.com/download/1/6/c/16c0ec7a-bb53-4aea-9020-cb2f80424322/SQL2005UpgradeTechRef.doc

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Amila chandrasekera" <achandra@xxxxxxxxxxx> wrote in message
news:%23h6t5u7SHHA.412@xxxxxxxxxxxxxxxxxxxxxxx
I need your advise on migrating a two node SQL 2000 cluster to new hardware
including servers and disks.


thanks.
Amila



.

Relevant Pages

  • Re: is data mirroing online? exchange2003 cluster
    ... There is no data replication between cluster nodes. ... So if your Shared Disks ... that contain the databases are down then your end users will not have access ... This is true of all deployments of Exchange we have to have ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: is data mirroing online? exchange2003 cluster
    ... There is no data replication between cluster nodes. ... So if your Shared Disks ... that contain the databases are down then your end users will not have access ... This is true of all deployments of Exchange we have to have ...
    (microsoft.public.exchange2000.admin)
  • Re: is data mirroing online? exchange2003 cluster
    ... There is no data replication between cluster nodes. ... So if your Shared Disks ... that contain the databases are down then your end users will not have access ... This is true of all deployments of Exchange we have to have ...
    (microsoft.public.exchange2000.general)
  • Re: Sun may have Solaris for Itanium already ready
    ... That cluster is comprised ... interconnects make a big difference to what kind of problems it can handle. ... >> simulators is written in C and gets compiled using standard compilers. ... Databases require a common store for performance reasons. ...
    (comp.sys.sun.hardware)
  • Re: Sun may have Solaris for Itanium already ready
    ... That cluster is comprised ... interconnects make a big difference to what kind of problems it can handle. ... >> simulators is written in C and gets compiled using standard compilers. ... Databases require a common store for performance reasons. ...
    (comp.unix.solaris)