You are here: SQL job error « MsSQL Server « IT news, forums, messages
SQL job error

Posted by paullie69 on 02/06/07 10:53

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация