Yes. A data file can reside only on one drive, but a database can have multiple filgroups and each filegroup can have multiple files, each on a different drive.
Roman
>Odd question (at least for me) ...
>
>A business partner asked if SQL Server data files can span multiple logical drives.
>
>Any help would be appreciated.
>
>Doug
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729