April 23, 2007 at 10:46 am
Hi All - Our SQL Backup log jobs keep failing intermittently with following error in the msdb..sysdbmaintplan_history table.
[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 idea what might cause the sudden failure of the job.
Suggestions comments are welcome.
Thanks
April 23, 2007 at 11:35 am
Do you have an exceptionally large log? Or is this server low on memory?
I've not seen this before.
April 23, 2007 at 12:15 pm
The log files are not that large (max 160 MB log backup size ) , what is the best way to find if server is low on memory?
Regards
May 9, 2007 at 4:27 am
I am having the same issue, I deleted the tlog maintenance plan and recreated it again, but no success. Can't understand I am successful in generating the Database backup and it doen't give any error there.
Checked the memory as well.
1662792 (KB) Target Server Memory
1662792 (KB) Total Server Memory
Not sure what does this mean is it the server does not have more memory now....
Please help me in this regard.
May 9, 2007 at 8:21 am
Some suggestions.
Check the total memory usage using tools, such as task manager.
Check if some other applications eating up your physical memory using the task manager. (If an application is not closed gracefully, the physical memory cannot release used memory. It is a problem on Windows system for a long time.)
Make sure if some other jobs are running at the same time. These jobs may eaten up your physical memory.
If you feel everything is ok, the last alternative may be to reboot your server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply