Options

Can someone decrypt this error/warning for me please? Backups seem ok, but the error says otherwise

mjnincmjninc Posts: 16 Bronze 1
in SQL Backup
Hello, I received this email regarding backup error and warning.  The backup has multiple DB's in it.  It seems when I look at SQL Backup, each DB shows a successful backup.  Towards the bottom it says the backup or restore was aborted, but the backup job appears successful.  Also, there are multiple databases that say they are offline, but also appear to have successful backups.

What should I look for in these emails to decrypt them to get to the bottom line of it please?  According to the email, backups didn't seem to happen, when looking at SQL Backup, they appear to have been successful.

----------------------------------------------------------------------------------------------------------------------------------------

5/19/2020 12:42:25 AM: Backing up server1 (full database) on SMITH instance to:

5/19/2020 12:42:25 AM:   L:\dbbackups\Userdbs\FULL_SMITH_server1_20200519_004225.sqb 

5/19/2020 12:42:25 AM: Deleting old backup file: L:\dbbackups\Userdbs\FULL_SMITH_server1_20200516_004230.sqb…

 5/19/2020 1:06:42 AM: Thread 0 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 1 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 2 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 3 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 4 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 5 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 6 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Thread 7 error:

Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

5/19/2020 1:06:42 AM:

5/19/2020 1:06:42 AM: Warning 167: Failed to get database size from server.

5/19/2020 1:06:42 AM: SQL error -2147467259: Communication link failure

5/19/2020 1:06:42 AM: SQL error 233: Shared Memory Provider: No process is on the other end of the pipe.

 

5/19/2020 1:06:42 AM: Connection lost.

5/19/2020 1:06:42 AM: SQL error 596: Cannot continue the execution because the session is in the kill state.

5/19/2020 1:06:42 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.

5/19/2020 1:06:42 AM: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_CDF31D88-1FDE-4379-98BF-2F8EA4223C74:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

5/19/2020 1:06:42 AM: SQL error 3202: Write on "SQLBACKUP_DC1111111-1FDE-4379-9999-2F8EA5544554" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

5/19/2020 1:06:42 AM: SQL error 3204: The backup or restore was aborted.

--------------------------------------------------------------------------------

 5/19/2020 1:06:42 AM: Backing up server2 (full database) on SMITH instance to:

5/19/2020 1:06:42 AM:   L:\dbbackups\Userdbs\FULL_SMITH_readyformsimpl_20200519_010642.sqb

 5/19/2020 1:06:42 AM: Database is offline.

--------------------------------------------------------------------------------

 

5/19/2020 1:06:42 AM: Backing up server3 (full database) on SMITH instance to:

5/19/2020 1:06:42 AM:   L:\dbbackups\Userdbs\FULL_SMITH_readyformstest_20200519_010642.sqb

 5/19/2020 1:06:42 AM: Database is offline.

--------------------------------------------------------------------------------

 5/19/2020 1:06:42 AM: Backing up server4 (full database) on SMITH instance to:

5/19/2020 1:06:42 AM:   L:\dbbackups\Userdbs\FULL_SMITH_Report_20200519_010642.sqb

 

5/19/2020 1:06:43 AM: Database is offline.

--------------------------------------------------------------------------------

 

Thank you

· Share on Twitter
Sign In or Register to comment.