SQL 2000 to SQL 2008 - Clustering and disk system questions
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Looks like no one else is interested...that's ok.
Another question, I'll want to keep the same SQL server name. Can I build the new cluster using server-temp and then rename once I'm ready to switch? I remember running into some kind of problem when I did this for SQL2000, but I don't remember exactly what the problem was.
Another question, I'll want to keep the same SQL server name. Can I build the new cluster using server-temp and then rename once I'm ready to switch? I remember running into some kind of problem when I did this for SQL2000, but I don't remember exactly what the problem was.
ASKER
I was hoping for some more hits but it seems that it wasn't meant to be. Seems like you win!! Thanks for the help.
ASKER