No, you wouldn't gain anything by manually spreading things over a RAID5. FG could be
considered if you foresee that you'll get separate physical partitions in the future.
Otherwise, try to make one db file per disk (i.e. 5 files in your case), to drive
disksubsystem reasonable optimal.
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
I created a new filegroup and now want to assign some tables to it. I
select the TABLE FILE GROUP and the TEXT FILE GROUP and select the new
filegroup name. The table is saved. However, when I reopen the table,
the TABLE FILE GROUP took the new name, but the TEXT FILE GROUP still
says "PRIMARY". Why won't the Text File Group accept the new filename?