Microsoft KB Archive/161599

= FIX: Temporary Dump Devices May Be Created with the Wrong Name =

Article ID: 161599

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 Q161599



BUG #: 15681 (6.0) 16411 (6.5)



SYMPTOMS
If temporary disk dump devices are used that contain spaces in the path or file name, the dump file may be created in the incorrect directory, or may be created with the incorrect name. However, the dump is valid to load if the file is specified correctly.



WORKAROUND
To work around this problem, do either of the following:


 * Create disk dump devices with the stored procedure sp_addumpdevice or SQL Enterprise Manager, and then dump and load with the device name rather than using the temporary dump device syntax.

-or-
 * Do not use spaces in the path or file name for temporary disk dump devices.



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 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.



MORE INFORMATION
Temporary disk dump devices are created by using the DISK=" " for the dump device.

The following example illustrates the problem:

DUMP DATABASE pubs TO DISK='c:\mssql\backup\disk test.dat'

Instead of creating a dump file named "disk test.dat," a file called "disk." is created.

Additional query words: headeronly

Keywords: kbfix kbusage KB161599

-

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

© Microsoft Corporation. All rights reserved.