General discussion


SQL backups failing

By BRNeyes ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Tony Hopkinson In reply to SQL backups failing

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.

Collapse -

by BRNeyes In reply to

Only some of the backups are failing and they all use the same account.

Collapse -

by glantz In reply to SQL backups failing

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.

Collapse -

by BRNeyes In reply to

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

Collapse -

by BRNeyes In reply to SQL backups failing

This question was closed by the author

Related Discussions

Related Forums