Post reply

Sql Clustering service Failover

  • June 27, 2002 at 9:17 am

    #78628

    Hi,

    I am new with clustering with SQL server,

    I am using 2 server with three physical disk

    my question it's:

    can i run full failover sql cluster server

    with those three disks or i have to add more,

    did i have to set them on each server, and the same volume lable

    Thanks

    Shahar

  • June 27, 2002 at 10:58 am

    #431772

    A typical SQL cluster looks like this:

    Two servers each with hardware RAID1 (2 disks) for the OS installation.

    One shared SCSI disk system with one RAID1 partition for the Quorum (2 disks), one RAID1 partition for the database logs (2 disks) and a RAID1 (ideally) or RAID5 (cheaper) partition for the data (2 or more disks).

    This builds you an active/passive cluster. (i.e. A single virtual server running on machine #1 and machine #2 acting as a hot-spare).

  • July 2, 2002 at 3:34 am

    #431948

    Hi,

    First thing:

    from what you wrote i understand that i can have 2 disks as RAID1 and on them i can put the OS, DBLogs and the data.

    2 more disks for the SCSI Shared disks.

    Is that true or should i use 2 disks for the rest and 2 disks for the DBLogs and diffrent disks for the data

    Thanks for your reply

    Shahar

  • July 2, 2002 at 7:50 am

    #431969

    The system must be configured so that all the "clustered" resources can be moved between nodes. This means that the cluster quorum, DB logs and data must all reside on shared disks. (Nothing associated with the base OS can be on a shared disk.)

    This is what I was recommending:

    Server 1

    ========

    Physical Disk 0 \__ RAID1, C:, install OS

    Physical Disk 1 /

    Server 2

    ========

    Physical Disk 2 \__ RAID1, C:, install OS

    Physical Disk 3 /

    Shared SCSI Disk Pack

    =====================

    Physical Disk 4 \__ RAID1, Q:, Quorum drive

    Physical Disk 5 /

    Physical Disk 6 \__ RAID1, L:, DB logs

    Physical Disk 8 /

    -- EITHER --

    Physical Disk 9 \__ RAID1, D:, DB data

    Physical Disk 10/

    -- OR --

    Physical Disk 9 \__ RAID5, D:, DB data

    Physical Disk 10|

    Physical Disk 11|

    : : 😐

    more disks /

    Check out http://www.microsoft.com/sql/techinfo/administration/2000/FailoverClustering.doc for more info.

  • July 2, 2002 at 8:01 am

    #431971

    Whoops: when counting disks, it looks like I forgot to include 7!

  • July 3, 2002 at 4:09 am

    #432035

    did it must to put the Quorum drive, DB logs, and the DB data each on separate disk

    i only have 3 physical disks on my server

    can i set them for testing?

    tx, for your time

    shahar

Viewing 6 posts - 1 through 5 (of 5 total)

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