FIX: Compatible Tape Drives May Not Read SQL Server Dumps

 Last reviewed: May 5, 1997
Article ID: Q152414

The information in this article applies to:
  • Microsoft SQL Server, version 6.0
BUG#: 13749 | 13753

SYMPTOMS

A SQL Server tape dump may not be usable on a similar tape drive if the two tape drives do not support the same tape marking mechanisms.

CAUSE

By default, SQL Server checks for tape marks using the following algorithm:

  1. Does the tape drive support Setmarks? If so, use Setmarks.

  2. Else does the tape drive support Filemarks? If so, use Filemarks.

If you dump to a tape drive that does not support Setmarks and then attempt to load the dump on a drive that does support Setmarks, SQL Server will not be able to load the dump. The same is true for the reverse scenario.

WORKAROUND

Starting with Service Pack 3, SQL Server now contains the trace flag 3206 that will reverse the SQL Server tape mark algorithm to the following:

  1. Does the tape drive support Filemarks? If so, use Filemarks.

  2. Else does the tape drive support Setmarks? If so, use Setmarks.

STATUS

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

MORE INFORMATION

SQL Server uses tape marks to determine things such as the end of a dump during loading and where to begin appending to a tape during a dump.

For information about enabling trace flags, page 727 in Part 8 Troubleshooting; Chapter 24 Additional Problem-Solving Techniques, Using Trace Flags, in the "Administrator's Companion."

Additional query words: QIC Setmarks, Filemarks
Keywords : kbbug6.00 kbhw kbprg SSrvGen
Version : 6.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 5, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.