I am backup in a few SQL databases from different servers and they are all reporting (1) error stating:
"21:05:50 I 1073741928 Established socket connection
21:04:53 E 3271 Processed 172040 pages for database 'MillenniumBRGuest', file 'MillenniumBRGuest' on file 1.
Processed 1 pages for database 'MillenniumBRGuest', file 'MillenniumBRGuest_log' on file 1.
A nonrecoverable I/O error occurred on file "\\payprodsclient\sqldump\MillenniumBRGuest.19 :" 64(The specified network name is no longer available.).
BACKUP DATABASE is terminating abnormally.
SQL:declare @dbName nvarchar(255), @device nvarchar(512), @sqlstring nvarchar(1024) set @dbName = ? set @device = ? select @sqlstring = N'backup database [' + @dbName + N'] to ' + @device + N' with init ' exec (@sqlstring) (MillenniumBRGuest)"
I am dumping to the dsclient and have not seen the I/O errors before.
What could be causing the I/O error?
I have checked the backup sets and they have completed successfully in the past. The last time was over a week ago.