Schedule backup fails

• lakahminaryanan

  Newbie

  Points: 2

  More actions

  September 6, 2005 at 12:06 am

  #110755

  When I take backup manually via EM backup works fine but when I schedule backup fails saying error [SQLSTATE 01000] (Message 3211)  Write on '\\remoteserver\AllSQLBcks\rm2kbomnir20\sebitest_bkp' failed, status = 64. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202)  Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.

  Remote server has enough space to backup. Sql agent has permission to write files.

  Pls, help what could have went wrong ? Pls, consider this as high priority as this happens to our production server.

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  September 6, 2005 at 4:44 am

  #587718

  Please do make sure that the account SQL Agent is using has the needed permissions.

  A quick way might be to just create and run a job that does

  exec master..xp_cmdshell 'dir \\remoteserver\AllSQLBcks\rm2kbomnir20'

  if that works, try (for write-test)

  exec master..xp_cmdshell 'dir \\remoteserver\AllSQLBcks\rm2kbomnir20 >> \\remoteserver\AllSQLBcks\rm2kbomnir20\TEST.txt'

  > '">

  /Kenneth