FIX: LOAD HEADERONLY Doesn't Report Files Cont on Another Tape (150891)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbfix kbusage KB150891 |
|---|
|