SQL 2000 to SQL 2008 - Clustering and disk system questions
Posted on 2009-12-23
We have an existing SAN connected 2000 SQL cluster running on Server 2003, we're now looking moving to Server 2008 and SQL 2008 in order to take advantage of some of the newer SQL capabilities (the software the company uses gets some added functionality that we're interested in).
Since we have relatively new servers, we're looking to do this without adding any new servers. I do have the same exact disk system available on the SAN, so I can match number of spindles and disk setup.
My idea was to evict Node 2 from the existing cluster, wipe and rebuild it with Sever 2008 and SQL 2008.
My questions are:
1. If my current SQL 2000 disk setup is working, is it sufficient to mirror it for SQL 2008? (I have 4 drives mirrored for data, 2 drives mirrored for logs, 2 drives mirrored for TempDB, and 2 drives mirrored for Master and Quorum).
a. I read that TempDB is used more in 2008, but I don't have a sense of how much more
2. Can I build a standalone cluster server and then convert it to a cluster? Can I build it as a cluster with only 1 node and add a 2nd note later?