> You can move the files by detaching the db, moving some of the files and
> reattaching it specifying the new physical locations of the files. It is
> hard to say if there will be performance improvements or not. But if you had
> I/O bottlenecks with the current configuration this should help.You didn't
> mention where the log files are located. If they are on the same raid 10 as
> the data you might consider using some new capacity for a Raid 10 dedicated
> to the log files.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Mike" discussions.microsoft.com> wrote in message
> news:A13A332F-C069-4794-9B06-989E5695B04C@microsoft.com...

>> We run our SAP SQL database on a SAN and we recently expanded our SAN
>> capacity for SAP. My question is, we have 7 database files for SAP
>> running
>> on a RAID 10 on 2 cabinets of 15 discs each.
>>
>> Can we move part of the SQL database files onto the new discs we just
>> implemented in the SAN and still have SAP find the data on those files?
>>
>> Also, will performance increase/decrease within SAP have the files split
>> up
>> like that?
>>
>> Thanks for your help!
>>
>> Mike

>
>