FIX: LOAD HEADERONLY Doesn't Report Files Cont on Another Tape

ID: Q150891

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5

BUG#: 15076 (6.00)

SYMPTOMS

The Dump Database command can continue or span a dump across multiple tapes. If the Load Headeronly command is used to verify the dump, it will not report files that span tapes.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

Consider the following scenario. The master, pubs, and a user database are dumped to a tape with a capacity of 1 GB and the user database has 1.5 GB space used. In this situation, the dump of the user database can not complete on the first tape but will complete if a second tape is mounted. If Load Headeronly is run on the first tape, it will report that 2 files exist on the tape containing dumps of the master and pubs databases. If Load Headeronly is run on the second tape, it will report that 0 files exist on the tape.

Additional query words: span


Keywords          : kbusage SSrvAdmin kbbug6.50 kbbug6.00 kbfix6.50.sp2 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 26, 1999