From: "Antti Kurenniemi" 

I don't think it has to be on the same drive where the boot is. If you have
an extra disk, try it: set the swap file to that other disk.


Antti Kurenniemi

"Ellen K"  wrote in message
news:a09ffa.8e945c{at}harborwebs.com...
> 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