Hi All,

We are facing insufficient memory issues on one of our production box with configuration SQL server 2000 /Service pack 3. When this issue came all our Applications will stop working, restarting the SQL server service will do the trick,but our management is looking for a permanent solution.

Here is the error from my errorlog

Error: 17803, Severity: 20, State: 5 Insufficient memory available..

And also sometimes while writing the backup we see the issues in my error log as well, seems it's not an issue with disk space as we have 90 GB free space.

18210 : BackupMedium::ReportIoError: write failure on backup device E:\\DBNAME_backup_incremental.BAK'. Operating system error 112(There is not enough space on the disk.).

Looking for some help and apprecaite your help in advance

Thanks,
Vamsi Krishna