December 3, 2003 at 11:43 am
I have defined a backup device to a network drive and after the backup starts, I recevie the following message. This is occurs after the device is being written to.
BackupMedium::ReportIoError: write failure on backup device '\\nyc-sql-bkp\nycsql07\LKEYDB_BKUP.BAK'. Operating system error 64(The specified network name is no longer available.).
TIA for your assistance.
December 3, 2003 at 1:14 pm
Can you ping the server nyc-sql-bkp from the sql server?
Is the share available?
Does the sql Agent account has permissions to access that share?
December 3, 2003 at 1:16 pm
The answer is yes to all of your questions. I was wondering if it might be a network issue. It works if I use northwind as the database to be backed up but not with a database of 15gb
December 8, 2003 at 3:51 am
I have had similar problems, in the end I have determined that SQL Server has problems with Copying very large files over networks. I tend to backup local and then copy that to the network location. Robocopy can be more reliable.
December 11, 2003 at 9:43 pm
I agree with the file size issue. I seem to only have problems when the file is over 2GB however I was trying to copy to a compressed folder. I uncompressed the folder and still got the same error if the file was over 2GB.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply