Backup failure in sql 2012

• premkuttan

  SSCommitted

  Points: 1934

  More actions

  January 30, 2020 at 9:28 pm

  #3721782

   

  Backup getting failed with below error

  The operating system returned the error '64(The specified network name is no longer available.)' while attempting 'SetEndoffile'

  The operating system returned the error '64(The specified network name is no longer available.)' while attempting 'FlushFileBuffers'

  this works well when i run it manually in ssms, fail when it runs as a job.

  any suggestions

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  January 31, 2020 at 10:25 am

  #3721948

  Probably permissions. Your agent doesn't have the same access you do.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning