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

Question

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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 · Answer 4

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: 172994 More actions · Answer 5

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.