September 17, 2008 at 3:42 am
Hi,
We have a critical production SQL 2000 server where the transaction logs are backed up every hr
We have made the decision that this needs to be every 30 mins.
i have changed the maintenance plan to reflect this but now When I run this it fails with insufficient system memory.
I am not even able to backup the model Log file.
Yes I can backup any other file except for logs, doesnt make sence.
I have deleted the plan and created a new one but still same.
Have tried with just t-sql but again the same message.
There is plenty of memory 4Gig and ntohing is running that shouldnt be.
I do not want to take the server down for a reboot unless this is a last resort.
this is the error log.
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SQLserver87' as 'ADMIN\SQLServiceAccount' (trusted)
Starting maintenance plan 'payments Transaction Log DB Maintenance Plan' on 17/09/2008 10:24:01
[1] Database payments: Transaction Log Backup...
Destination: [E:\payments Log Backups\payments_tlog_200809171024.TRN]
[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.
End of maintenance plan 'payments Transaction Log DB Maintenance Plan' on 17/09/2008 10:24:01
SQLMAINT.EXE Process Exit Code: 1 (Failed)
September 17, 2008 at 4:15 am
Resolved:
I gave both log files more space and whala' all working
If only the error was more meaningfull
September 17, 2008 at 7:14 am
I am just confused with the error message insufficiant memory and your sollution (you increased the log file space)
could you please explain me more... what happend.
Rajesh Kasturi
September 17, 2008 at 8:37 am
What was happening? Well everytime i tried to backup the log file manually, using t-sql or starting a agent job I would get this error message.
My good mate google thrown up some posts with the same error message.
One I found was here http://www.tek-tips.com/viewthread.cfm?qid=1257380&page=1
The log files did not need increasing, but hey anything is worth a trying.
I gave the payments log and extra 50mb and the systems model log an extra 5mb.
Tried again backing up and they worked.
strange i know, I was all set for a reboot but thankfully avoided.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply