Windows Forum

Ask something
Discussion Locked

MS SQL Backups Larger then 2 GB fail

0 helpful
2 replies

by dsmart

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

Things I have done:
1. Increase the Persistent route time or better known as the Auto connection timout setting.
2. Added Backup Server to the host files on SQL Server.
3. Tried to backup using the IP address
4. Tried to backup using the UNC name
5. Increased the timeout seccession on P-II 450 Server
6. Checked the netbios name seccession timeout. It is set to 1 hour on all W2K Servers.
7. Tried disabling SMB per MS Doc - Q161372

2 replies

by sebastiansarrow

We had a similar issue with a Compaq ML570. Microsoft, Veritas and Compaq labored over it for months. In the end it turns out that the RAID controller card and the tape backup card were fighting for bus mastering. We dropped the backup card to a slower slot and everything works fine now. If you need the nity / grity technical detail, email me at BThomas@Liguori.Org

Benjamin

This discussion is closed to new replies.