Backup job failed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Backup job failed

Author

Topic

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-10-08 : 01:36:42

The backup job scheduled at 11PM failed. Below is the error I got from the Windows event log.
What does this mean-"Operating system error 64(The specified network name is no longer available.)".
How do i troubleshoot this error?

BackupDiskFile::RequestDurableMedia: failure on backup device '\\\Complete\User\AsReporting_backup_200910072300.bak'. Operating system error 64(The specified network name is no longer available.).

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-10-08 : 03:16:26

Well, I don't mean to be rude and state the obvious here but isn't it pretty clear?? "The specified network name is no longer available" tells me that at the time of the backup "\\Complete\User\" was not accessible. Could it be that you have three backslashes instead of the two you are supposed to?

Change
'\\\Complete\User\AsReporting_backup_200910072300.bak'
to
'\\Complete\User\AsReporting_backup_200910072300.bak'
maybe...?

- Lumbago
http://xkcd.com/327/

rpschulte
Starting Member

1 Post

Posted - 2009-11-17 : 10:07:37

I have the same problem and am certain that the target location is correct, driving me nuts for weeks. Rebooting the target server resolves but it comes back sooner or later.

Date 11/17/2009 8:59:22 AM
Log SQL Server (Current - 11/17/2009 8:59:00 AM)

Source spid119

Message
BackupDiskFile::RequestDurableMedia: failure on backup device '\\djjgxnas1\sqldb\webgxsql\inventoryDB.bak'. Operating system error 64(The specified network name is no longer available.).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources