General discussion


Mirroring SQL Trans. Log on RAID5 server

By joeh ·
I wanted to know if there were any configurations (S/W or H/W), preferrably H/W that will allow me to mirror my SQL transaction log on a single RAID-5 server. I am in a single-server domain (using a Dell Small Business Server)with dual processors and would like to be able to segregate my data and SQL transaction log for maintenance/back-up. However, I would like to utilize both processors on the server - can an external device (i.e. disk duplicator) be utilized to do this. If so, where can I see/research that option (vendor?)?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Digerati In reply to Mirroring SQL Trans. Log ...

One cheap method would be to add two IDE drives to the server and in the drive config set them up as mirrored drives. Then assign your log file to the new drive. Note also if you format the drives as FAT instead of NTFS your will get better performance. This is only suggested for transaction log files though.

Related Discussions

Related Forums