Backup intermittently fails. OS Error:32

Hi,
We've been having an usual problem with our SQL server
backup. The database is around 41Gb, which does a full
database dump to a .bak daily, and then transaction log
dumps every 15mins. However, intermittently the full
backup will fail with the following:
nightlyrun.log
Msg 3201, Level 16, State 1, Server EARTH, Line 24
Cannot open backup device 'dratlas_backup'. Device error
or
device off-line. See the SQL Server error log for more
details.
Msg 3013, Level 16, State 1, Server EARTH, Line 24
BACKUP DATABASE is terminating abnormally.
ERRORLOG
2004-04-28 02:27:58.27 spid58 DBCC CHECKDB (hrlink)
executed by sa found 0 errors and repaired 0 errors.
2004-04-28 02:28:00.77 backup Database log truncated:
Database: hrlink.
2004-04-28 02:28:13.16 spid58
BackupDiskFile::CreateMedia: Backup
device '\\jupiter\dump$\dratlas_backup.bak' failed to
create. Operating system error = 32(error not found).
2004-04-28 02:28:13.18 backup BACKUP failed to
complete the command
The network share is always 100% available to the SQL
server on a 1Gb core network. As I said, this is
intermittent, and may fail once a week, or five times a
week, and nothing has changed on the servers or network.
The knowledge base does not include any information about
the OS error or Msg 3201
Any help will be much appreciated.
Thankyou.
Regards,
DavidA single network interruption can an error such as this. With a 41GB file
being backed up over the network there is plenty of time for this to occur.
Another common cause is if you are reusing an existing device (either
appending or initing) and you have a tape backup trying to backup that
device at the same time. If these files are backed up to tape by a
different process you may want to check the timing of it compared to the
backup failure times.
--
Andrew J. Kelly SQL MVP
"David Meldrum" <david.meldrum@.skilled.com.au> wrote in message
news:526d01c42cb4$07a18da0$a301280a@.phx.gbl...
> Hi,
> We've been having an usual problem with our SQL server
> backup. The database is around 41Gb, which does a full
> database dump to a .bak daily, and then transaction log
> dumps every 15mins. However, intermittently the full
> backup will fail with the following:
> nightlyrun.log
> Msg 3201, Level 16, State 1, Server EARTH, Line 24
> Cannot open backup device 'dratlas_backup'. Device error
> or
> device off-line. See the SQL Server error log for more
> details.
> Msg 3013, Level 16, State 1, Server EARTH, Line 24
> BACKUP DATABASE is terminating abnormally.
> ERRORLOG
> 2004-04-28 02:27:58.27 spid58 DBCC CHECKDB (hrlink)
> executed by sa found 0 errors and repaired 0 errors.
> 2004-04-28 02:28:00.77 backup Database log truncated:
> Database: hrlink.
> 2004-04-28 02:28:13.16 spid58
> BackupDiskFile::CreateMedia: Backup
> device '\\jupiter\dump$\dratlas_backup.bak' failed to
> create. Operating system error = 32(error not found).
> 2004-04-28 02:28:13.18 backup BACKUP failed to
> complete the command
> The network share is always 100% available to the SQL
> server on a 1Gb core network. As I said, this is
> intermittent, and may fail once a week, or five times a
> week, and nothing has changed on the servers or network.
> The knowledge base does not include any information about
> the OS error or Msg 3201
> Any help will be much appreciated.
> Thankyou.
> Regards,
> David