General discussion

  • Creator
    Topic
  • #2182527

    SQL backups failing

    Locked

    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.

All Comments

  • Author
    Replies
    • #3182539

      Reply To: SQL backups failing

      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.

      • #3190396

        Reply To: SQL backups failing

        by brneyes ·

        In reply to Reply To: SQL backups failing

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

    • #3183981

      Reply To: SQL backups failing

      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.

      • #3190395

        Reply To: SQL backups failing

        by brneyes ·

        In reply to Reply To: SQL backups failing

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

    • #3190394

      Reply To: SQL backups failing

      by brneyes ·

      In reply to SQL backups failing

      This question was closed by the author

Viewing 2 reply threads