Posted by Steve on 02/06/07 16:12

On Feb 6, 2:53 am, paulli...@hotmail.com wrote:
> Hi all
>
> Inherited environment :
>
> Windows 2003 SP1 Ent
> SQL 2000 Standard
> 16 GB RAM
>
> BOOT INI Switches : /3GB /PAE
>
> I understand that SQL 2000 standard can only address > 2 GB and
> therefore the /3GB switch will only rob the OS of a GB of RAM without
> giving it to SQL as it can only use > 2GB
>
> We have an active X job invoked from a SQL job ran overnight which
> copies large CSVs (> 5GB) from one folder to another on the SQL
> server. This runs ok for a while (normally after a reboot) but
> intermittently comes back with "Not enough server storage is available
> to process this command"
>
> The files can then be copied over manually without problem and the
> rest of the job ran successfully
>
> Could this error be related to only having 1 GB available to the OS as
> its a file copy ?
>
> Would it be best to remove both the /3GB AND /PAE switches or just
> the /3GB switch to give the OS at least 2 GB to play with ?
>
> Thankyou in advance for your replies
>
> Cheers
>
> Paul

Can you post the code the job executes?

[Back to original message]