Post reply

basic Requrements of Clustering

  • September 13, 2010 at 11:58 pm

    #223829

    Hi Team,

    Can you any body guide me basic requerements to installing MS SQL SERVER Clustering ..

    Tx

  • September 15, 2010 at 2:58 pm

    #1221729

    do you mean requirements or install guide?

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

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

  • September 15, 2010 at 8:01 pm

    #1221841

    yes i need clustering installation in MS SQL SERVER 2008

  • September 16, 2010 at 12:34 am

    #1221919

    You will find plenty of white papers on net.

    download.microsoft.com/.../SQLServer2008FailoverCluster.docx

    "More Green More Oxygen !! Plant a tree today"

  • September 16, 2010 at 2:11 pm

    #1222583

    There's a great 4 part guide at MSSQL Tips that starts here... http://www.mssqltips.com/tip.asp?tip=1687. I used it for our installation and it was invaluable.

  • September 17, 2010 at 1:32 am

    #1222774

    shiv-356842 (9/15/2010)

    yes i need clustering installation in MS SQL SERVER 2008

    Are you using windows 2003 or 2008 clustering?

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

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

  • September 17, 2010 at 2:30 am

    #1222807

    2008 Sql server

  • September 17, 2010 at 4:07 am

    #1222869

    shiv-356842 (9/17/2010)

    2008 Sql server

    which edition of Windows?

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

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

  • September 17, 2010 at 4:17 am

    #1222872

    windows 2003

  • September 18, 2010 at 3:53 am

    #1223447

    shiv-356842 (9/17/2010)

    windows 2003

    Hi sjiv

    Is your OS configured for clustering?

    Refer the Dave's provided link, that may useful for you.

    Ali
    MCTS SQL Server2k8

  • September 18, 2010 at 9:02 am

    #1223469

    Hi

    check my guide at the following link for SQL Server 2008 on a Windows 2003 cluster

    http://www.stokecs.co.uk/techdocs/Creating%20a%202%20node%20SQL%20Server%202008%20Cluster%20Configuration%20using%20Windows%202003%20MSCS.pdf

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

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

  • September 18, 2010 at 2:03 pm

    #1223501

    Perry Whittle (9/18/2010)

    Hi

    check my guide at the following link for SQL Server 2008 on a Windows 2003 cluster

    Perry, the link doesnt work for me. i guess the underlying uRL is missing.


    Pradeep Singh

  • September 18, 2010 at 4:57 pm

    #1223528

    try now, the pdf is fairly large so download to disk and then open!

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

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

  • September 21, 2010 at 5:56 am

    #1224707

    do you configure windows cluster too? or are you interested in sql server cluster only?

    if second option, speak to your network & storaga guys and ask them to configure storage as following:

    1) Data files - raid5 (or 10 if you can afford or require it)

    2) Log files - raid 10

    3) Temp DB file - raid 10

    4) Quorum

    5) MS DTC

    Also ask to be provided a static IP for your SQL server cluster (unless you will be using DHCP)

  • September 21, 2010 at 6:47 am

    #1224744

    Hi Team,

    Thank you very much for your support

    I am learning new things her only.

    Tx 🙂

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

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