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

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  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.

• HanShi

  SSC-Dedicated

  Points: 33512

  More actions

  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’! **

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 3, 2016 at 6:12 am

  #1910323

  No

  Thanks.