January 28, 2008 at 8:07 am
HI.
All of a sudden none of my transaction log backups will run from my sql agent jobs. I also tried to right clidk on the database name in enterprise manager and do ALL TASKS and backup log and no luck theire either. I get the following error:
There is insufficient system memory to run this query.
I was able to go into query analyzer and do run:
BACKUP LOG dbname WITH TRUNCATE_ONLY
and this ran fine. But when I went back to enterprise manager and try to run the backup tlog job, it abends.
I can run database backups just fine.
any suggestionis?
Juanita
January 28, 2008 at 3:39 pm
Did you check whether or not any big application running on this server? Could you shrink your log file?
January 29, 2008 at 8:07 am
HI.
Well our technical people did some hardware work on the server last night and rebooted and voila.. all of my tlog backups are running fine.
So I think it was a 'hardware' issue.
But thank you for the suggestion, I never got to try it.
Juanita
May 29, 2008 at 5:16 am
I heard it on the hearsay (ie another forum) that Microsoft advise that it is memory leakage when using linked servers. A reboot is the workaround.
May 29, 2008 at 9:31 pm
Microsoft claimed that the memory leak in linked servers is fixed in SP4.
May 30, 2008 at 1:54 am
Fair enough - but we have just one server (admittedly out of hundreds) where the transaction logs will suddenly stop backing up due to insufficient system memory. All our SQL2000 boxes are SP4.
May 30, 2008 at 10:50 am
If it happens again, you may run
sp_who2 active
to check what process is biting the memory.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply