Monday, March 12, 2012

New or upgrade

We are planning to move to SQL Server 2005 and we do have A/A cluster .
Which is the most efficient way to move from SQL Server 2000 A/A to SQL
Server 2005 A/A cluster.
1) Upgrade from SQL Server 2000 to SQL Server 2005
2) Install a new installion of SQL Server 2005 cluster and attach the 2000
databases.
I would do the second (install and migrate) the potential for nplanned
downtime is lower with that technique.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"IT" <IT@.discussions.microsoft.com> wrote in message
news:64232C5C-4D57-484F-BA5F-4621102121F4@.microsoft.com...
> We are planning to move to SQL Server 2005 and we do have A/A cluster .
> Which is the most efficient way to move from SQL Server 2000 A/A to SQL
> Server 2005 A/A cluster.
> 1) Upgrade from SQL Server 2000 to SQL Server 2005
> 2) Install a new installion of SQL Server 2005 cluster and attach the 2000
> databases.
>
|||My experiences indicate that a parallel (new and migrate) will most often be
the least fraught with 'unexpected' consequences.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"IT" <IT@.discussions.microsoft.com> wrote in message
news:64232C5C-4D57-484F-BA5F-4621102121F4@.microsoft.com...
> We are planning to move to SQL Server 2005 and we do have A/A cluster .
> Which is the most efficient way to move from SQL Server 2000 A/A to SQL
> Server 2005 A/A cluster.
> 1) Upgrade from SQL Server 2000 to SQL Server 2005
> 2) Install a new installion of SQL Server 2005 cluster and attach the 2000
> databases.
>

No comments:

Post a Comment