Clearing of remembered mapped drives in SQL server for backuping up to netowrk drives
Posted on 2014-09-17
In the past I have been backing up my SQL databases to a removable or network mapped drive. I had to enable xp_cmdshell etc and when I try to map a drive the SQL states that this is a remembered drive, even though it doesn't exist. I would like to clear out those remembered drives without it messing up my SQL server install.
Does anyone know a command to do this? Also I don't know much SQL, but the output of the Remembered drive asks about overwriting it. However I don't know the syntax to do that.