Post reply

installing failover cluster

  • December 13, 2006 at 9:10 am

    #175195

    We had installed sql server 2005 locally on 2 servers, but now want to set them up as failover cluster.  Do we need to uninstall sql server and then install following the instructions for installing sql server 2005 failover clustering? Or is there instructions somewhere that can set up as a failover cluster these servers as they are already installed?  Thanks for any help.

  • December 13, 2006 at 9:17 am

    #677820

    Denise

    I haven't watched this video myself yet, but it may have the answers to some of your questions.

    http://www.jumpstarttv.com/Media.aspx?vid=33

    John

  • December 13, 2006 at 9:51 am

    #677840

    Thanks for the link. I watched the video and it helped me see what to expect with the cluster set up.  It didn't address whether I should uninstall first though. Any thoughts on that? Thanks!

  • December 13, 2006 at 10:03 am

    #677844

    Denise

    I haven't worked with clustering and SQL Server 2005, but if it were SQL Server 2000 then I would back up the databases, uninstall SQL Server and then build my cluster.  That way I could be sure of getting a clean install.

    John

  • December 14, 2006 at 7:19 am

    #678070

    Denise

    I have already installed a (64-bit) SQL 2005 failover cluster. Honestly I do not know if you can make out a failover Cluster of two existing servers, I have heavy doubts. Just think if you want to build a active/active cluster, that you will have a default and a named instance....

    I suggest you as John did) to build a new failover cluster.

    Moreno

  • December 14, 2006 at 9:27 am

    #678126

    yes.. you need to install the cluster first.. then install SQL Server. The cluster needs to have common disk space configured etc.

    Thanks

    Rich

  • December 14, 2006 at 1:39 pm

    #678200

    Thanks, I will uninstall first.  Do you know of any instructions for setting up the failover cluster with 2 servers and a SAN for the database?  Thanks again!

  • December 15, 2006 at 2:54 am

    #678279

    Denise

    I imagine you'll find plenty of white papers and the like on Microsoft's website.

    John

  • December 15, 2006 at 3:03 am

    #678281

    Hi Denise

    check for this white paper on Microsoft

    "Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services".

    As Rich mentioned, you have first to build the cluster on the operating system base. You will find plenty of documentation on Microsoft site.

    Moreno

  • December 15, 2006 at 7:00 am

    #678317

    Hi Denise.. here is good place to start

    http://msdn2.microsoft.com/en-us/library/ms189134.aspx

    Thanks

    Rich

  • December 15, 2006 at 7:08 am

    #678322

    Thanks everyone. I'll be reading everything I can find.

  • December 20, 2006 at 7:15 am

    #679112

    Back to the uninstall, I uninstalled using add/remove programs.  The database files are still there though. Should I just go delete the whole folder "Microsoft SQL Server"?  Thanks again!

  • December 20, 2006 at 7:23 am

    #679114

    Hi Denise

    What do you mean with database files ? After uninstall there are some folders and files of the binaries remaining on the drive. You can delete them, but it is not mandatory.

    Regards,

    Moreno

  • December 20, 2006 at 9:28 am

    #679152

    No, there are some .mdf and .ldf files.

  • December 20, 2006 at 11:02 am

    #679178

    If there is any issue with your uninstallation... here is the manual uninstallation.

    http://support.microsoft.com/default.aspx/kb/909967

    Even if you don't delete the files/folders.. it should be fine because every time you install sql server 2005 it creates new folder prefixing with numbers (mssql.1, mssql.2...) so I don't think you need to worry about it...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply