Doing a SQL Backup on a Database 2 GB or larger fails with System Error 64.
Running SQL Server 2000 on Windows 2000 Server, on a Compaq ML530 using a SCSI-3 Raid 5 Array for the Data drive and Raid 1 for the O/S drive.
The Server that the backupgoes to is an Dual Processor P-II 450 Using NT4. The data drive is Raid 5 and the O/S drive is Raid 1. The Controller is an AAA-131U2 Raid Controller.
I can copy the Database between the two Servers but when I set SQL to Backup to the P-II450 Server I get Several Errors:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Lynx] TO DISK = N’\\smesqlbk01\E$\SMESQL01\dump\JavedLynxfull.bak’ WITH INIT, NOUNLOAD , NAME = N’Lynx backup’, NOSKIP , STATS = 10, NOFORMAT
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device ‘\\192.168.1.89\E$\SMESQL01\dump\JavedLynxfull.bak’. Operating system error 64(The specified network name is no longer available.).
This happens at the end of the backup. The SQL Server reports adnormal Termination of the Backup.
BACKUP DATABASE [Data] TO DISK = N’\\192.168.1.89\D$\SQLSERVER\dump\datafull.bak’ WITH INIT, NOUNLOAD , NAME = N’Data backup’, NOSKIP , STATS = 10, NOFORMAT
The result is
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 318808 pages for database ‘Data’, file ‘Order_Data’ on file 1.
100 percent backed up.
Processed 143 pages for database ‘Data’, file ‘Order_Log’ on file 1.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.