SQL backups failing

pts.
Tags:
SQL Server
SQL Server 2000
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

What ID is being used to perform the backups?

Discuss This Question: 12  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BRNeyes
    The user has SA privileges.
    0 pointsBadges:
    report
  • BRNeyes
    We had 5 jobs fail last night, 2 of which have failed regularly for the past 20 days. The other 3 have run fine. I am able to successfully run the jobs manually.
    0 pointsBadges:
    report
  • BeerMaker
    The question about the ID has to do with the Windows network ID that would be used for the network share. It seems like you have permissions to run the backups on the SQL server machine but probably not permissions to access the network share. When you login as ???? to run the backups you are using a different account to access the network share and thats why it works. Be sure to post the fix when you figure it out. -- Good Luck
    0 pointsBadges:
    report
  • BRNeyes
    This user is also a member of Domain Admins and is in the local Administrator group on the server where this file is being written.
    0 pointsBadges:
    report
  • Pedwards17
    Is there a space issue on the destination drive? If the succeeding backups were of small databases and the large ones were failing, hard drive space could be the culprit.
    0 pointsBadges:
    report
  • BRNeyes
    Not a space issue. There's 69.5 GB free space on the server.
    0 pointsBadges:
    report
  • Jackass
    Are you using a share name like bakserversharename? If so, could it have been removed?
    0 pointsBadges:
    report
  • BRNeyes
    The UNC path does exist and the backups actually start just fine. The error messages occur after the backups have started.
    0 pointsBadges:
    report
  • Harinck
    The cause of this problem may be the size of your backup. See the microsoft article at 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285997' about how creating snapshots fails due to network directory caching. The problem you've seems a OS problem. So, I think it's worth to try a absolute file path instead of UNC path.
    0 pointsBadges:
    report
  • BRNeyes
    We are not seeing the errors in the event log that the KB article talks about. The only errors we see are SQLSERVERAGENT and MSSQLSERVER errors on the SQL server. Last night we changed the path of some of the backups that fail most frequently from a server to our NAS, and they worked. One that we did not change failed again last night, so it must be something to do with the server we are writing to, even though most of the backups work just fine.
    0 pointsBadges:
    report
  • HaeCons
    I have a similar problem, since middle of last week, all my maintenance plans with backup (transaction and full) are hanging. The backup file is present, but the job is still active. I have to stop manually the job or kill the process sqlmaint.exe. When I run a manual backup from the Query Analyser it works. Did you try a backup from the Query Analyser ? We are still woking on this issue...
    0 pointsBadges:
    report
  • BRNeyes
    We upgraded the server where the backups are being written to 2003 and have not a single backup fail since. Thanks for all the help!!
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following