Post reply

Difference between cluster setup -- SQL server 2000 and Sql server 2005

  • September 26, 2008 at 4:56 am

    #123873

    Hi,

    Can you please give some points on the differences between the Installation of Clusters on SQL 200 and SQL 2005 servers (on Windows Server 2003 SP1). Please point me to informative links.

    TIA

  • September 26, 2008 at 5:38 am

    #877560

    Read the Installing SQL Server in Books Online - look under Preparing... -> Configuring High Availability.

    Biggest difference is that you need to create AD-group(s).

  • September 26, 2008 at 8:04 am

    #877716

    Watch out if you're using SSIS as well, as by default this will not be clustered and when you fail over to the second node packages will not execute from scheduled jobs. There are numerous links out there as to how to cluster it (works fine but against Microsoft recommendations) or how to put in place workarounds.

    cheers

Viewing 3 posts - 1 through 2 (of 2 total)

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