Post reply

clustering

  • February 28, 2011 at 5:38 am

    #231746

    can any one send me the material of how to install cluster in sql 2008 ?

    how to failover a cluster in sql 2005 ?

  • February 28, 2011 at 10:50 am

    #1292452

    Hi

    message me your email address and i have a couple of docs you may find useful

    😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 28, 2011 at 11:42 am

    #1292494

    ramyours2003 (2/28/2011)

    can any one send me the material of how to install cluster in sql 2008 ?

    This is covered in the SQL Server 2008 Upgrade Technical Reference Guide.

    how to failover a cluster in sql 2005 ?

    Go to cluster administrator, and connect to the appropriate cluster. Right click the SQL group, and select "Move". This will move the group over to (one of ) the passive node(s).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • February 28, 2011 at 2:22 pm

    #1292594

    Here's a great set of articles I found very helpfull.

    http://www.mssqltips.com/tip.asp?tip=1687

    http://www.mssqltips.com/tip.asp?tip=1698

    http://www.mssqltips.com/tip.asp?tip=1709

    http://www.mssqltips.com/tip.asp?tip=1721

    There are a few gotchas around virtual SQL Server names if you have multiple named instances. If you intend runing Reporting Services on the cluster I strongly recommend that you install it in its own instance on each node with nothing else in the instance.

    To get Integration Services to work correctly you need to edit the MsDtsSrvr.ini.xml file on BOTH nodes. You will find the file roughly here: C:\Program Files\Microsoft SQL Server\100\DTS\Binn

    Note that you can edit both the MSDB section and the File System section. You must put the packages on a clusterd disk fot them to be visible from both nodes otherwise you will have problems after a failover.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

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

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