Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-02-21 : 16:24:04
|
| We have SQL 2000 prod db's in a clustered environment, we are thinking of moving to SQL 2005, Since upgrading the existing production db(clustered) to sql 2005 is not recommended, we are planning to install sql 2005 in a new server and then migrate the sql 2000 databases to the new server which has 2005 in it. Instead of having clustering which requires special hardware and since it might get costly to implement, we are thinking of going with database mirroring as it does'nt need any additional hardware and we can achieve whatever we get with clustering. And also since database mirroring has automatic server failover and client failover mechanism, we are seriuosly thinking of using Database Mirroring instead of Clustering when we go to SQL 2005. Please let us know your ideas. Thanks!!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 16:27:59
|
| First of all, you can upgrade clustered sql2k to sql2k5, we did it on many clusters. For db mirroring, you need test you apps and ensure they are capable to connect to mirrored db automatically. |
 |
|
|
|
|
|
Upgrade SQL 2000 to 2005 in clustered environment