Not a SQL GURU, but a SharePoint installation has like a dozen DB's under the covers. Depending on usage, you MAY see some value in storing a couple of them (indexing, and I forgettheotherone), on a separate mirror.
If I can find the doc we generated here 18 months or so ago, I'll pass more on... but IIRC, it was based on a sizing/allocation recommendation paper from MS you should be able to find... s-c From: Bob Fronk [mailto:[email protected]] Sent: Friday, May 14, 2010 9:04 AM To: NT System Admin Issues Subject: SharePoint - SQL Backend setup I am designing my SQL server for a SharePoint farm. I have an iSCSI array with 15 - 420GB SAS drives. I want to use the array to house the transaction logs, database and backups. My thought is to use two drives in a RAID1 for the transaction logs (420GB), Three drives in a RAID5 for the DB Backups (837GB) and Ten drives in a RAID 10 for the database (2TB). The server will be backed up by DPM, so the DB Backups volume won't need to hold but a day or two of backups. Any SQL gurus see a problem with this setup? BF ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
