December 9, 2003 at 10:07 pm
MS SQL Server 2000 Enterprise Edition Service Pack 3
on MS Windows Advanced Server Service Pack 4
Attempts to made backup on the network drive are failed.
There are two databases with this feature. One has 1400Mb data and 100Mb log. Another has 4410Mb data and 1000Mb log. First database has about 80% successful attempts. Second - only 10%. However there are a lot of databases about 300-500Mb that are backed up successfully always and one that has 4100Mb data and 1000Mb log, that is backed up successfully always too.
Backups on the local drives are always successful.
Copying entire catalog \data (about 20Gb mdf and ldf files) using windows explorer on the same network drive is always successful.
Symptoms:
After issuing this statement:
backup database LargeDB to disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
we have result:
1 percent backed up.
2 percent backed up.
3 percent backed up.
.....................
97 percent backed up.
98 percent backed up.
99 percent backed up.
Processed 563608 pages for database 'LargeDB', file 'LargeDBData' on file 1.
100 percent backed up.
Processed 1 pages for database 'LargeDB', file 'LargeDBlog' on file 1.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
SQL Server log contains two records:
BackupDiskFile::RequestDurableMedia: failure on backup device '\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error 64(error not found).
BACKUP failed to complete the command backup database LargeDB to disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
Application event log contains two records:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device '\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error 64(error not found).
3041 :
BACKUP failed to complete the command backup database LargeDB to disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
System event log has no records
Events logs from file server has no records.
Attempt to restore from the "unsuccessful" backup file always is successful.
What should I do?
Good luck.
Good luck.
December 10, 2003 at 6:50 am
Do you have the option of backing up the database to a file on the local system and then copying the file across? This would ensure, regardless of network problems, you always get your backup.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply