Post reply

SQL Backup failed with exit code: 790 SQL error code: 1222 [SQLSTATE 42000] (Error 50000). The step failed.

  • November 2, 2016 at 9:37 am

    #314604

    Hi Experts

    I found that sometimes one bkp job fails due to the error -

    SQL Backup failed with exit code: 790 SQL error code: 1222 [SQLSTATE 42000] (Error 50000). The step failed.

    The bkp is running via the redgate tool. I have notced that it fails at one of the dbs which has size close to 200 GB. The job does not fail always, but 3/4 times failed in the last 1 month.

    I have joined the below tables and collected data from Ring Buffer.

    FROM sys.dm_os_ring_buffers

    CROSS JOIN sys.dm_os_sys_info

    Question is, other than this is there any other way available to check memory pressue happens during the time the job runs? The total server memory is 32 gb, sql has 28 gb (fairly a good size)

    Thanks

    Thanks.

  • November 3, 2016 at 2:25 am

    #1910291

    Is any additional information mentioned in the Redgate Backup log file (\Red Gate\SQL Backup\Log\<instance name>)

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • November 3, 2016 at 6:12 am

    #1910323

    No

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply