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.