PRASAD R
1 Copper

SQL Backups are Failing randomly after sometime

Hello ,

SQL Backups are failing with below error , backups will write for sometime and at some point of random time it fails with below error .

Please help..

38008 15/12/2017 12:00:26  5 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical unknown XBSA error 995 (0x3e3)

29085 15/12/2017 12:00:26  5 0 0 25480 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Microsoft SQL Server Provider error:

0 15/12/2017 12:00:26  1 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR notice D:/views/nw/9.0/nsr/db_apps/bsmsql/sqlxbsacompforsave.cpp(968): Calling job completion attributes for saveset: 1513339224 (-1)

38006 15/12/2017 12:00:26  5 0 0 25480 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Write on "Legato#71531b60-07df-4b3e-a1f9-f17e1199e9c1" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.).

38006 15/12/2017 12:00:26  5 0 0 25480 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical A nonrecoverable I/O error occurred on file "Legato#71531b60-07df-4b3e-a1f9-f17e1199e9c1:" 995(The I/O operation has been aborted because of either a thread exit or an application request.)..

38006 15/12/2017 12:00:26  5 0 0 25480 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical BACKUP LOG is terminating abnormally..

53084 15/12/2017 12:00:26  5 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Processing model failed, the item will be skipped.

142036 15/12/2017 12:00:26  0 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR info Backup configured with maxtransfersize = 4194304

38008 15/12/2017 12:00:27  5 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical unknown XBSA error 995 (0x3e3)

0 15/12/2017 12:00:27  1 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR notice D:/views/nw/9.0/nsr/db_apps/bsmsql/sqlxbsacompforsave.cpp(968): Calling job completion attributes for saveset: 1513339226 (-1)

29085 15/12/2017 12:00:27  5 0 0 26468 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Microsoft SQL Server Provider error:

38006 15/12/2017 12:00:27  5 0 0 26468 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Write on "Legato#192ac871-ade0-43d9-9b22-e625229974d4" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.).

38006 15/12/2017 12:00:27  5 0 0 26468 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical A nonrecoverable I/O error occurred on file "Legato#192ac871-ade0-43d9-9b22-e625229974d4:" 995(The I/O operation has been aborted because of either a thread exit or an application request.)..

38006 15/12/2017 12:00:27  5 0 0 26468 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical BACKUP DATABASE is terminating abnormally..

53084 15/12/2017 12:00:28  5 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR critical Processing msdb failed, the item will be skipped.

Unable to render the following message: 0 1513339228 0 0 0 13172 24044 0 r2ixedb313.kworld.kpmg.com (pid24044) NSR info 2 %s 1 23 34

Regards,

prasad

Labels (1)
Tags (3)
0 Kudos
2 Replies
ble1
6 Indium

Re: SQL Backups are Failing randomly after sometime

Might be something simple as inactivity timeout.  Try to change it from default 30 to 0.

0 Kudos
SurajPujari
3 Argentium

Re: SQL Backups are Failing randomly after sometime

Check the XSBA file, it should tell you if it was network or something else causing this failure.

0 Kudos