backup jobs just start failing with error 300

joes

SQL Backup 4.2.0.425 - Professional edition.

I get these errors every now and then for now reason. No permissions have changed, I have serveral servers backing up to the same shares with no issue.

Below is the error msg.



SQL Backup job failed with exitcode: 300 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.


Can someone help please.

thanks

petey

When SQL Backup runs a backup, it requires SQL Server to have a certain amount of contiguous free memory. If SQL Server is unable to service the request, the backup process is aborted and reattempted, with a smaller amount of contiguous free memory. If SQL Server is able to service that request, the backup proceeds. However, a warning (300) is logged to inform you that SQL Server may be running into a low memory condition.

If you look for the corresponding SQL Backup log file (default folder is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>, it should provide some memory statistics at the time the initial backup failed.

You can configure SQL Backup to request a lower amount of memory initially, by using the MAXTRANSFERSIZE option. The help file has details on this.

joes

thank you for your answer, now the error makes more sense.