How can we help you today? How can we help you today?

backup jobs just start failing with error 300

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
joes
0

Comments

2 comments

Sort by
  • 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.
    petey
    0
  • joes
    thank you for your answer, now the error makes more sense.
    joes
    0

Add comment

Please sign in to leave a comment.