Networks

Ask something
Discussion Locked

SQL backups failing

0 helpful
5 replies

by brneyes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
All of a sudden some of our SQL backups are failing with this error: Operating system error 64(The specified network name is no longer available.). These backups are being written to a different server, then backed up to disk. To rule out DNS issues, I changed the failing ones to use IP. Still failing. Turned off virus scanner, so it wouldn't scan while the file was being written. Still failing. The only thing that has changed was the applying of the June Security Patches.

5 replies

by tony hopkinson

Make sure the account you are running sql server as can access the network/drive/directory path in question. Backing up from sql server across networks is quite a performance hit, personnally I'd dot it to the hard drive and then scehdule a command file to move it across the network. I'd suspect somethings gone awry with the permissions.

by glantz

You don't mention the source or destination servers operating system's. If the server you are using as your destination server uses Windows Small Business Server 2003 you may be having problems with the new enhanced security in Service Pack 1. Let us know what the OS's are.

by brneyes

The destination server is 2000. We upgraded the server to 2003 and have not had a backup fail since then.

This discussion is closed to new replies.