Microsoft KB Archive/158736

= Creating Devices in SQL is Slow with Removable Media Installed =

Article ID: 158736

Article Last Modified on 12/5/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft Windows NT Workstation 3.5
 * Microsoft Windows NT Workstation 3.51
 * Microsoft Windows NT Workstation 4.0 Developer Edition
 * Microsoft Windows NT Server 3.5
 * Microsoft Windows NT Server 3.51
 * Microsoft Windows NT Server 4.0 Standard Edition

-



This article was previously published under Q158736



SYMPTOMS
When creating a new device in an application, such as SQL Enterprise Manager (SEM), it may take several minutes to display the dialog box with the current available devices and/or may possibly time out.



CAUSE
If the computer has removable media, such as a removable floppy disk drive, and it is not connected at the time the new device is being created, the system times out when polling for available devices.

SQL Server makes a Win32 API call to GetDiskFreeSpace, which can take an extended period of time to determine if the media is currently loaded. Any other application that makes a call to GetDiskFreeSpace may experience the same behavior.



RESOLUTION
To resolve this problem, perform one of the following:
 * Before creating the device, re-connect the removable media, such as a removable floppy disk drive or a zip drive.

-or-


 * If you are running SEM, you can increase the Query Timeout value by clicking the Tools Menu, then clicking Preferences, and then configure then the Connection tab.

Keywords: kbnetwork kbprb KB158736

-

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

© Microsoft Corporation. All rights reserved.