PRB: DUMP/LOAD with Tape May Be Slower on Windows NT 4.0

ID: Q161600

The information in this article applies to:

Microsoft SQL Server version 6.5

SYMPTOMS

With some SCSI controllers and tape drives that do not support hardware compression, SQL Server 6.5 dump and load functions with tape may be slower than prior versions of SQL Server on computers running Windows NT 4.0.

WORKAROUND

To work around this problem, try one of the following:

Put the tape drive on a different SCSI adapter.

Dump to disk files rather than to tape.

Use a tape drive that supports hardware compression.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: blocksize backup restore


Keywords          : kb3rdparty kbhw SSrvAdmin SSrvGen 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 7, 1999