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 |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2004-01-21 : 02:36:53
|
| Environment:SQL Server 2000 SP3a on W2K Advanced Server SP4.1 IBM Server x440 with FastT700 Storage (Fibre Channel)We need to buy another IBM Server x440 or x445 and we would like to make a cluster.Question 1:Once we build the Cluster with the installation of the Cluster Service, making the W2K Cluster, is it possible to upgrade the default instance of SQL Server to a default clusterd instance of SQL Server?In BOL I have found a note that explain how to do this but I have some doubts.When I installed SQL Server I placed the system files on the C: drive, the DB files on our SAN on disk E: and the log files on disk F:.Question 2:If we would like to use Windows Server 2003 what would be the possibility for an upgrade?I mean, should I erase all and start with Windows Server 2003 setup or can you suggest to upgrade the OS first, from W2K Advanced Server, and then cluster SQL Server if possible?Can you advice please?Any help is really appreciated.Thank you very much for your time.FrancoFranco |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-01-21 : 09:58:51
|
| I've never done an "upgrade" cluster installation, so I'm not sure how much this is going to help you. I know that when we installed SQL Server for the first time, you install it to the virtual server name. So, If you have ServerA and ServerB, your SQL Server that runs on those two gets a virtual name like MySQLCluster or soemthing.I don't think I'd reccomend doing an upgrade. on anything when it comes to clustering. I'd really reccomend starting from two clean PC's. As far as your SAN, I think that you could leave your data on the SAN, but I suspect that you'll either need to detach the databases in question or do a backup of the databases, and restore them once you have the cluster setup and the SAN setup.Helpful links:http://www.sql-server-performance.com/articles_clustering_log_shipping.asphttp://www.sql-server-performance.com/clustering_2000.aspMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-01-21 : 10:36:13
|
| you can't upgrade a non-clustered install to a clustered install. However, moving the database from the old instance to the clustered instance is pretty trivial using the detach and attach stored procs.-ec |
|
|
|
|
|
|
|
|
Clustering SQL Server 2000