Article ID: 163152
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q163152
BUG #: 15689 (6.0); 16517 (6.5); 18234 (6.5)
SYMPTOMS
A DUMP and LOAD may fail if a tape drive does not support variable block mode and the MaximumBlockSize reported by the GetTapeParameters API call is less than 32,768 bytes.
WORKAROUND
To work around this problem, dump databases, transaction logs and tables to disk devices, and then use the Windows NT Server Backup utility (located in Administrative Tools group) to back up the disk devices to tape.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0 Service Pack 3.
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:
197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a
For more information, contact your primary support provider.
MORE INFORMATION
With the SQL Server 6.5 Service Pack 5, you can now use trace flag 3207. This trace flag must be enabled for both the tape drives to work correctly with SQL Server 6.5 DUMP and LOAD statements. Trace flag 3207 works with both older and newer tape drive devices.
NOTE: To change the blocksize of a tape, the tape must be blank. If you want to make sure a tape is blank, you can use NTBACKUP to erase it. However, you may need to use the /NOPOLL switch on NTBACKUP.
For additional information, see the following article or articles in the Microsoft Knowledge Base:
177657 Explanation of NTBackup /Nopoll Parameter Is Incorrect
Microsoft has created a utility called SQLTPTST to determine the capabilities of a tape drive. You can obtain this tool from Microsoft Product Support Services. Currently the file is at ftp://ftp.microsoft.com/bussys/sql/transfer/
The following errors may occur with this problem:
- The client receives the following error and the SQL Server error log does not contain any errors:
- The SQL Server errorlog contains the following errors:
Additional query words: sp SP1 SP2 SP3 headeronly QIC size variable blocksize blocksizes sizes
Keywords: kbbug kbfix kbusage KB163152