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

• Microsoft SQL Server, versions 6.0 and 6.5

       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="<filename>" for the dump device.

The following example illustrates the problem:

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