problem running the DBCC
hello,
I have Backup Exec 12.5 and for several days I can not do the backup of SQL database
Shows the following error:
V-79-57344-65085 - There was a problem running the DBCC.
There is insufficient system memory to run this query.
I can not find information to solve it. Can anyone help me?
Thanks
Generic Solution:
Check the settings for both min server memory (MB) and max server memory (MB). If max server memory (MB) is a value close to the value of min server memory (MB), then increase the max server memory (MB) value.
Check the size of the virtual memory paging file. If possible, increase the size of the file.For SQL Server 2005:
Install following HotFix and Restart Server.Additionally following DBCC Commands can be ran to free memory:
- DBCC FREESYSTEMCACHE
- DBCC FREESESSIONCACHE
- DBCC FREEPROCCACHE
