Forum Discussion

villex's avatar
villex
Level 4
13 years ago

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 ...
12.x and Earlier
Backing Up
Backup and Recovery
Backup Exec
  • ZeRoC00L's avatar
    ZeRoC00L
    13 years ago

    http://blog.sqlauthority.com/2007/03/27/sql-server-fix-error-701-there-is-insufficient-system-memory-to-run-this-query/

    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
ZeRoC00L's avatar
ZeRoC00L
Level 6
13 years ago

http://blog.sqlauthority.com/2007/03/27/sql-server-fix-error-701-there-is-insufficient-system-memory-to-run-this-query/

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