The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'DeleteFile' on

• gary1

  SSC-Insane

  Points: 21152

  More actions

  June 15, 2011 at 11:48 am

  #252017

  Hi,

  I have configured logshipping in standby mode and used the shared path to copy the log backup files Z:\Logshipping_Backups.

  But, I'm getting the below error frequently in event viewer Application log . Here, the log shipping is working fine even though, the error is occurring.

  Log Name: Application

  Source: MSSQL$INS1

  Date: 6/15/2011 6:00:13 AM

  Event ID: 3634

  Task Category: Backup

  Level: Error

  Keywords: Classic

  User: abc\mssqlsrv

  Computer: abc.com

  Description:

  The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'DeleteFile' on 'Z:\Backups\RestoreCheckpointDB9.CKP'.

  The error reporting the path as Z:\Backups but I'm copying the log backup files to Z:\Logshipping_Backups.

  Please advice

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  June 15, 2011 at 11:50 am

  #1339187

  Have you verified the directory exists and permissions are there?

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• gary1

  SSC-Insane

  Points: 21152

  More actions

  June 15, 2011 at 12:13 pm

  #1339203

  Have you verified the directory exists and permissions are there

  Yes. The path Z:\Backups does not exist.

  The path that exist is Z:\Logshipping_Backups (the path mentioned for copying the log backup files in Logshipping wizard) and the sql service account has read/write rights to the share Z:\Logshipping_Backups

  Thanks

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  June 15, 2011 at 12:24 pm

  #1339210

  You may want to script out the logshipping from that wizard and confirm that the paths in the script.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  June 18, 2011 at 12:42 pm

  #1340811

  At some point that directory existed and may have been defined as the default location for backups.

  create the directory 'Z:\Backups and give SQL permissions to it, the message should go

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

• Brandie Tarvin

  SSC Guru

  Points: 173105

  More actions

  June 20, 2011 at 6:46 am

  #1341138

  It definitely sounds like someone renamed a folder and didn't bother to update the log shipping job.

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.