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