Microsoft KB Archive/153006

= FIX: Dump or Load w/Tape Devices Results in Errors, AVs =

Article ID: 153006

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q153006





SYMPTOMS
Attempts to dump or load with tape devices may generate errors 3201, tbswritecheck, or access violations (AVs). Msg 3201 and the tbswritecheck errors are seen when attempting to dump; the AV may occur during the load.



WORKAROUND
Do not dump to a tape device; dump and load using a different type of dump device, such as disk. If dumping to disk, use another backup package, such as Windows NT Backup, to archive the dump file to tape.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. The problem does not occur in SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.



MORE INFORMATION
The behavior and error messages may vary from computer to computer. Some computers may report a Msg 3201 while the same tape drive and software may work correctly on a different computer, or the load process may generate an access violation (AV).

The 3201 and tbswritecheck errors may occur on any of the DUMP commands (DATABASE, TRANSACTION), and the AV may occur on any of the LOAD commands (DATABASE, TRANSACTION, TABLE).

For a robust backup and restore strategy, Microsoft recommends occasional verification that dumps can be loaded, along with additional testing when a device or software is changed. Certain database errors may also prevent a successful load, so it is important to run the recommended DBCC commands at the time of each backup.

Additional query words: dump load tape AV access violation

Keywords: kbbug kbfix KB153006

-

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

© Microsoft Corporation. All rights reserved.