Assuming that all the databases and applications were successfully checked by the Upgrade Advisor, what method would you choose to upgrade SQL SERVER 2000 Instance on cluster with 110 databases to SQL 2005:
1) Install 2005 on a new cluster machine, transfer logins, upgrade and test DB by DB and than transfer jobs, DTS (if possible), etc
2) Install SQL Server 2000 on the new cluster machine, copy all databases (including system databases) and than upgrade everything in-place
Of course, assuming also that all the 2005 installation pre-requisites are taken care of before the installations...
?
Thanks.
"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.
1) Install 2005 on a new cluster machine, transfer logins, upgrade and test DB by DB and than transfer jobs, DTS (if possible), etc
2) Install SQL Server 2000 on the new cluster machine, copy all databases (including system databases) and than upgrade everything in-place
Of course, assuming also that all the 2005 installation pre-requisites are taken care of before the installations...
?
Thanks.
"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.