backup log failing

Hi,
All these days full backups and log backups are fine and suddenly the log
backup is failing for the databases with error message in error log as
downgrading backup buffers from 960k to 64k and when ran in QA it says
insufficient system memory.
there is no additiona load on this db server and the server is not busy.
Please suggest how to resolve this problem
thanks
ShamaTry setting the MAX memory setting to allow for several hundred MB's for the
OS at all times.
Andrew J. Kelly SQL MVP
"Shama" <Shama@.discussions.microsoft.com> wrote in message
news:6A0FFA49-7098-464E-9B8D-05CF0145FB10@.microsoft.com...
> Hi,
> All these days full backups and log backups are fine and suddenly the log
> backup is failing for the databases with error message in error log as
> downgrading backup buffers from 960k to 64k and when ran in QA it says
> insufficient system memory.
> there is no additiona load on this db server and the server is not busy.
> Please suggest how to resolve this problem
> thanks
> Shama|||We have not changed any settings for sp_configure and awe has not been enabl
ed
sql server SE edition with SP4 with 4GB RAM.
MAX memory setting =2147483647
and getting error "not enough storage is available to process this command"
when try to start the backup log job.
all of sudden we r getting this problem.
pl suggest
"Andrew J. Kelly" wrote:

> Try setting the MAX memory setting to allow for several hundred MB's for t
he
> OS at all times.
> --
> Andrew J. Kelly SQL MVP
> "Shama" <Shama@.discussions.microsoft.com> wrote in message
> news:6A0FFA49-7098-464E-9B8D-05CF0145FB10@.microsoft.com...
>
>|||SQL 2000 standard edition can only use 2GB max anyway and you have 4GB. I
don't recognize the error messages but it sounds like you may have some kind
of memory leak that is eating up system memory. I don't know if this is
MemToLeave or OS specific memory. Have you tried rebooting?
Andrew J. Kelly SQL MVP
"Shama" <Shama@.discussions.microsoft.com> wrote in message
news:46434329-39B4-4ACE-BBED-B376FC70EE16@.microsoft.com...[vbcol=seagreen]
> We have not changed any settings for sp_configure and awe has not been
> enabled
> sql server SE edition with SP4 with 4GB RAM.
> MAX memory setting =2147483647
> and getting error "not enough storage is available to process this
> command"
> when try to start the backup log job.
> all of sudden we r getting this problem.
> pl suggest
> "Andrew J. Kelly" wrote:
>|||We have restarted the SQL Server and it looks fine now.
when I perform full backup/any query no issues encountered.
when I ran backup log manually in QA few times it says enough memory is not
available to create UMS scheduler,later on it says insufficient system memor
y
.
when I try start the backup log job it says not enough storage is available
to process this command"
how to find whether it is MemToLeave or OS specific memory ?
what shall I do if it reoccurs,doing restart regularly is not acceptable.
"Andrew J. Kelly" wrote:

> SQL 2000 standard edition can only use 2GB max anyway and you have 4GB. I
> don't recognize the error messages but it sounds like you may have some ki
nd
> of memory leak that is eating up system memory. I don't know if this is
> MemToLeave or OS specific memory. Have you tried rebooting?
> --
> Andrew J. Kelly SQL MVP
> "Shama" <Shama@.discussions.microsoft.com> wrote in message
> news:46434329-39B4-4ACE-BBED-B376FC70EE16@.microsoft.com...
>
>|||Are you running any 3rd party software to do backups? In any case this
sounds like a bug and you might best be served by calling MS PSS.
http://www.support.microsoft.com/de...id=fh;EN-US;sql SQL
Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"Shama" <Shama@.discussions.microsoft.com> wrote in message
news:797C34AE-7BB3-4FFC-8471-5270675C81AB@.microsoft.com...[vbcol=seagreen]
> We have restarted the SQL Server and it looks fine now.
> when I perform full backup/any query no issues encountered.
> when I ran backup log manually in QA few times it says enough memory is
> not
> available to create UMS scheduler,later on it says insufficient system
> memory
> .
> when I try start the backup log job it says not enough storage is
> available
> to process this command"
> how to find whether it is MemToLeave or OS specific memory ?
> what shall I do if it reoccurs,doing restart regularly is not acceptable.
>
> "Andrew J. Kelly" wrote:
>