Microsoft KB Archive/150891

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

Article ID: 150891

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q150891



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: kbbug kbfix kbusage KB150891

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.