Network backup failure

• 
  Hi Jonathan,
  
  5270 Error: SQL Backup Agent service is no longer running (error codes)
  
  Which suggests to me that the core service was unreachable or it crashed. I wonder what the exact conditions were for this to happen?
  
  Thanks,
  
  Robin

  RBA June 10, 2009 11:27

  - 0 +
• 
  Hi,
  
  I have just bundled the error text in an email to Matt as he asked about my query "Jobs in progress - mixed messages" and it was connected to that.
  
  If you take a look at the files there and need more info please feel free to call me.
  
  regards
  Jonathan

  fatherjack2 June 10, 2009 11:38

  - 0 +
• 
  In the folder where the SQL Backup service is installed, is there a file named SQBCoreService_bugreport.txt? If there is, could you please send this file to us?
  
  Thanks.

  petey June 25, 2009 02:08

  - 0 +
• 
  Sorry Pete,
  
  I have searched the whole HDD and there is no file with that name.
  
  Jonathan

  fatherjack2 June 25, 2009 05:02

  - 0 +
• 
  Perhaps the SQL Backup Agent service did not have rights to create that file. Could you please run the following from Query Analyzer/Management Studio:
  

  EXEC master..sqbutility 9997
  

  Does SQBCoreService_bugreport.txt get generated in the SQL Backup service folder?
  
  Thanks.

  petey June 25, 2009 05:36

  - 0 +
• 
  Script executed successfully, returned 1 row result:NULL
  
  File "SQBCoreService_(LOCAL)_bugreport.txt" now exists.

  fatherjack2 June 25, 2009 05:43

  - 0 +
• 
  Thanks for running the test, it means that the service did have rights to create the file.
  
  That would suggest that the service did not crash, but was stopped, thus triggering error 5270.

  petey June 25, 2009 22:54

  - 0 +

Add comment

Please sign in to leave a comment.