Backup Problem

My backup fails with:
10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up.
[SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000]
(Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50
percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up.
[SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000]
(Message 3211) Write on 'WednesdaylogsAM' failed, status = 64. See the SQL
Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP LOG
is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
When I look at the log I get:
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\Sapbackup\GIS\Backup\LOG-WED-AM\WednesdaylogsAM.BAK'. Operating system
error 64(The specified network name is no longer available.).
I can get to the folder where this file resides, so I have ruled out
security. What does this mean?This looks like you have glitches in the network or somewhere in the
communication path of the server you are backing up to. Backup is very
touchy about errors in the communication (as it should be) between the DB
server and the destination. Most normal network traffic will just resend
the packet but the backup will usually fail.
--
Andrew J. Kelly SQL MVP
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:361DA327-4899-4CD2-9BAC-CCE310D9A76C@.microsoft.com...
> My backup fails with:
> 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed
> up.
> [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000]
> (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50
> percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up.
> [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000]
> (Message 3211) Write on 'WednesdaylogsAM' failed, status = 64. See the
> SQL
> Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP
> LOG
> is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step
> failed.
> When I look at the log I get:
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\Sapbackup\GIS\Backup\LOG-WED-AM\WednesdaylogsAM.BAK'. Operating system
> error 64(The specified network name is no longer available.).
> I can get to the folder where this file resides, so I have ruled out
> security. What does this mean?|||You most likely ran out of disk space during the backup. Is there
enough free space on the disk to contain the entire DB? I'm guessing
not, since only about 70% of your DB gets backed up before the OS whinges.
Cheers,
Mike.
Jack wrote:
> My backup fails with:
> 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up.
> [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000]
> (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50
> percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up.
> [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000]
> (Message 3211) Write on 'WednesdaylogsAM' failed, status = 64. See the SQL
> Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP LOG
> is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> When I look at the log I get:
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\Sapbackup\GIS\Backup\LOG-WED-AM\WednesdaylogsAM.BAK'. Operating system
> error 64(The specified network name is no longer available.).
> I can get to the folder where this file resides, so I have ruled out
> security. What does this mean?