donebert
asked on
Clearing of remembered mapped drives in SQL server for backuping up to netowrk drives
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.
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.
If you are running the dos commands from SQL with xp_cmdshell it is possible that the OS is waiting for a response that is not provided(you can't provide feedback through xp_cmdshell). You can try to run the command directly in prompt window and give all the requested answers.
ASKER
That is correct the OS is waiting for a response to overwrite the remembered connection Y/N. No valid response was provided, therefore it does not allow me to see that drive in SQL disk backup. It states it has a remembered connection. Not sure if xp cmd shell has something to clear out remembered mapped drives.
ASKER
Here is what sql query shows
sql-drive-map-error.docx
sql-drive-map-error.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.