The drive is disconnected, and I'm off the network. How do I unmap the drive?
I can't test this here as I'm not on a network, but I think it's a case of doing this:
- Right-click Network in Windows Explorer.
- Select Disconnect network drive....
- In the list that appears, right-click the drive you wish to remove and select Remove.
I think it's something like that but as I say, I can't test it here.
On the command line, try:
This shows all currently mapped drives. If the one you're looking for is in the list, you can use:
net use x: /delete
where X: is the drive you're trying to remove. But if the drive has been removed, there may be no such drive letter shown. In that case, just type the Remote identifier for the mapping:
net use 192.168.10.11\WorkFiles /delete
For the disconnected drive, for those who have SQL Server Management Studio in your pc, just run this query.
Exec master.dbo.xp_cmdshell 'net use x: /delete'
- change the 'x' according to the drive name..
- not sure if it will work with other database..
- if your xp_cmdshell is not working or inactive, and this error occurs:
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.
xp_cmdshell by running this query:
-- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1 GO -- To update the currently configured value for advanced options. RECONFIGURE GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1 GO -- To update the currently configured value for this feature. RECONFIGURE GO
There is a more forceful way to get rid of dead links to mapped network drives.
You could delete the reference in your registry.
Just open "regedit.exe" and expand the key "HKEY_CURRENT_USER" and the key "Network". There you will see keys with letters that will represent the Mapped Drive Letters. When you delete a letter on "regedit.exe", the mapped drive letter will vanish on the next Windows restart cycle.
None of the above worked for me in Windows 10 for disconnected USB drives. What did work was:
- Right click on the Windows icon and select "Disk Management"
- Find the drive letter that is no longer used in the list of disks
- Right click on "Disk" and select "Change Drive Letter and Paths"
- Then select "Remove"