SQL 2000 to SQL 2008 - Clustering and disk system questions

Posted on 2009-12-23
Last Modified: 2012-05-08
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?
Question by:ITDharam
    LVL 7

    Accepted Solution

    I think your basic idea is fine.
    Evict one node and reimage it as Server 2008, build a new one node Microsoft Windows Cluster. Install SQL Server 2008 as a clustered instance.
    Migrate/upgrade your databases
    Reimage the 2nd machine and join it to the new cluster.

    Basic performance considerations for tempdb continue to apply. Try to put tempdb on its own separate fast disk. Assuming your Servers are multiprocessor, set up temp db to have as many data files as there are processors (or cores). For example, on my 2cpu quadcore server, I have 8  datafiles making up tempdb.
    LVL 8

    Author Comment

    Thank you pettmans, I'm hoping to get a couple more responses for confirmation.
    LVL 8

    Author Comment

    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.
    LVL 8

    Author Closing Comment

    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.

    Featured Post

    Do email signature updates give you a headache?

    Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

    Join & Write a Comment

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now