Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Msg 3202, Level 16, State 1, Line 1
Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Available storage is 400 GB and database backup size with compression is 50GB, still backup is failing. Kindly assist.
The error message "Not enough server storage is available to process this command" is a Windows error message that can be extremely misleading. The error message indicates there is not enough RAM available to complete the operation.
It is highly likely that Windows is very low on free memory - check the SQL Server "max server memory" setting to ensure there is a reasonable amount of memory left for the operating system.
This command shows how much memory SQL Server is configured to use:
EXEC sys.sp_configure 'max server memory (MB)';
See What is a deterministic method for evaluating a sensible buffer pool size? for details about what this value should be.
If you see this error, open Windows Task Manager and check how much free memory Windows has.
