Sharing Storage – What must be shared? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sharing Storage – What must be shared?

I’m new to clustering and have just begun to research how to configure a SQL Server cluster. I know we want to have our data and logs on a SAN. What about tempdb and backups? I like to separate tempdb from data and log drives and I also like to backup databases to a dedicated drive. With a cluster, must tempdb and backups also be on the SAN? Also, can someone save me a few minutes and point me to a good link for configuring a SQL cluster? Thanks, Dave
All disks used by SQL server must be shared disks in the cluster. On the SAN in your case. Cluster info:
SANs vary from one model to another. In some SANS, you might be able to dedicate specific RAIDed drives for specific purposes, such as mdb, ldf, tempdb, and backups. On other SANS, disks are virtualized and you just carve out a logical section instead of specifying exactly which drives will be used for what specific purpose. ——————————–
Brad M. McGehee, SQL Server MVP
Put all Databases on the SAN, like Brad mentioned depending on the SAN you can place TempDB and TLogs on seperate RAID arrays, go with RAID 10 when ever possible otherwise place TempDB and TLogs on RAID 1. You can place backups on the SAN as well, we backup all our databases to disk then from disk directly to tape. Raulie