SQL Server Performance Forum – Threads Archive
Transaction Logs on Mounted Volume?I am currently installing a database for an app I developed, and so far, so good. I am a SQL Server BI developer rather than an administrator. My question is about my clustered volumes and mount points. 2 months ago, I gave the client general guidance on a database disk config, ie. log on mirrored drives, data on Raid 10 or Raid 5, os on mirrored drives, distributed I/O etc. Certainly that applies to a single server installation, but what about a clustered instance. Does this advice still hold? Right now, the cluster has a quorum disk, a Raid 10 data volume, and a Mirrored Volume for logs, all part of the same cluster group. I have mounted the Mirrored volume as a Data volume directory (D:Logs), and put my sql server transaction logs on the mirrored volume via the mount point. I think this is a pretty good config, but I wanted the group opinion. Is putting log files on a separate volume via a mount point a "Safe" thing to do? I am not sure I am clear on the implications with regard to recoverability and failover. The logs will be pretty small, and I have the disk space to put them anywhere. The client has a small IT Group, but no senior level sql guys, but they do have a competent network admin type guy.
Yes, links for thishttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx &http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/harag04.mspx and applies to SQL 2005 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.