Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 701:

[aruopna]

My tlogs part of db maintainence plans failed n the output file captured the error shown below.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 701: [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.

Any help appreciated in advance.

Thanks
Arun

[rmiao]

How much memory does the server have? How much used by sql?

[aruopna]

The server has 16384 MB ram.... sql consumes just around 199mb now.

-PFA

[rmiao]

How did you set memory in sql? Should give it more. What's sql version and sp level by the way? Sql2k sp4 has awe related bug, need apply post sp4 fix.

[aruopna]

the sql memory is dynamically configured and ranges from 32 mb to 15000 mb.. the version is

Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

restarting the sql server solved my headache but I know its not kinda best practice... pls advise

thanks

[rmiao]

First of all, you have to leave os at least 2gb memory. Did you enable awe? How much memory sql uses? You should check that in perfmon.