From: Ellen K. 

Thanks!    :)

On Wed, 15 Dec 2004 08:43:08 GMT, John Beckett
 wrote in message
:

>Yes, on a WIndows computer you can have several pagefiles (each on a
>separate physical disk). The GUI (ISTR System Properties, Advanced,
>Performance...) allows you to add several. I think the only trick is that
>to remove a pagefile (if you wanted to) you set its size to zero. You need
>to reboot.
>
>John
>
>Ellen K  wrote in message
>news::
>> Can I have multiple swap files on one server?   One of my SQL Server boxes
>> doesn't have much room on the array where the boot partition is... ISTR that
>> there needs to be a swap file on the boot partition so that if the box blows
up
>> the memory has where to dump to.  But in addition to this can I also have a
>> swap file on one or more of the other arrays?   (The reason I'm asking is
that
>> I want to run some stuff that's going to need a lot of memory, possibly more
>> than will be available after subtracting out what SS and the O/S need, and
I'd
>> like it to have real room to swap to.)
>>
>> TIA

--- BBBS/NT v4.01 Flag-5