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 2000 Forums
 SQL Server Administration (2000)
 Operating system error 64

Author  Topic 

gfahrlander
Starting Member

23 Posts

Posted - 2003-08-21 : 14:26:45
I've been doing backups across the network using UNC naming (\\Servername\Sharename\Path\File). Suddenly I'm getting the following error 3 to 30 minutes after the backup has started.
"Operating system error 64(The specified network name is no longer available.)."

Shares are in place, SQL Server agent is a domain user with permissions, what am I missing?

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-21 : 14:32:02
You've got a network problem, meaning the error has nothing to do with SQL Server. This is why backing up a database over a network is not recommended. You should always backup the database to the local disk then copy the file to the other location.

Network problems like this might not occur that often, but you can't afford to not get a database backup, so you should always backup to the local disk first.

Tara
Go to Top of Page
   

- Advertisement -