Disks, MSDTC & Transaction Logs

Hello,

I want to set up a two-nodes SQL 2000 Win2003 R2 x64 failover cluster and
I've got some questions:

- I've got 2 DELL servers, the shared storage is: 4 disks (73GB 15K) in
direct attached storage. If I mirror 2 of these disks to use them as Quorum
Disk and mirror the other 2 disks to use them for the SQL Data Disk, I've
got no disk for Transaction Logs and MSDTC... Am I right? How can I fix
this? With more disks?

- The second thing is: how can I store SQL 2000 Transaction Logs in a
different disk than the one I use for SQL Data files? I've seen nothing
during setup...

Thnaks in advance!!

Cheers,

Petrus


.

Relevant Pages

  • Solaris RAID failover problems
    ... My intent is to mirror the drives completely, ... Can't read disk label. ... WARNING: md: d10: needs maintenance ... WARNING: forceload of misc/md_trans failed ...
    (comp.unix.solaris)
  • Re: Huge Av Disk Queue Length
    ... Write performance = 130 per mirror ... Mixed performance at a 1:1 R:W ratio = 195 IOPS per mirror. ... (sort of like weighted fair queuing for disk performance). ... put a 3020 in each location with FCP shelves for the primary data and SATA ...
    (microsoft.public.exchange.admin)
  • Re: how i locate swap area
    ... what you have with the command 'vgdisplay -v vg00'. ... Why Mirror Copies is 0? ... it seems that you have no disk mirroring. ... Primary Partition Table: ...
    (comp.sys.hp.hpux)
  • Re: Using mirroring to replace drive?
    ... I upgrade and rebuild it. ... drive which happens to be the system disk. ... and mirror the failing drive on the new drive. ... upgrade to 7.0 after establishing the new good drives). ...
    (freebsd-questions)
  • Re: VxVM : Cant open /dev/vx/rdsk/bootdg/rootvol
    ... disk as explained in the document). ... before "Reattaching the plexes rootvol-01, swapvol-01, to the relevant ... of the root mirror and change the state of the rootdisk to detached. ... # vxplex att rootvol-01 rootvol-02 ...
    (comp.unix.solaris)