SQL 2000 Transactional Backup Failures.
Posted on 2013-01-03
After doing as much research as I can online I'm currently stuck. Plus my knowledge of sql 2000 is smaller then a grain of salt.
Just recently I have started to receive this error from our sql 2000 box.
JOB RUN: 'Transaction Log Backup Job for DB Maintenance Plan 'DataConnect'' was run on 1/3/2013 at 11:35:00 AM
DURATION: 0 hours, 28 minutes, 40 seconds
MESSAGES: The job failed. The Job was invoked by Schedule 40 (Schedule 1). The last step to run was step 1 (Step 1).
I look at the history and the log file and this is what I find:
Executed as user: SVAMAIN\sqlservice. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
I then go to the SQL Server logs and view the current log.
At the same time when I received the email that the job failed I am able to find this:
BackupDiskFile::RequestDurableMedia: failure on backup device \\xxxxx. Operating system error 64(The specified network name is no longer available.).
When I go to the location of where the backup file is there are transactional logs there (whether they are complete or not is another question but data was written to the network locations).
Things have been going fine until today. Nothing on the network has changed. A few months back I had to move the backups from our SAN to our NAS due to storage issues, migrations, etc. The hop count hasn't changed and it's the same millsecond response time when doing a ping and tracert.
From all the research I can see is that SQL 2000 really doesn't like it when the network connection get's congested and slows down. Instead of continuing to keep running it fails the job. Is there a way to force the Maintenance plan to keep going regardless of network congestion or slow response times from the destination NIC?
Thank you for any help that you can provide :)