Solved

Clearing of remembered mapped drives in SQL server for backuping up to netowrk drives

Posted on 2014-09-17
4
573 Views
Last Modified: 2014-11-04
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.
0
Comment
Question by:donebert
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:Zberteoc
ID: 40328546
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.
0
 
LVL 1

Author Comment

by:donebert
ID: 40328575
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.
0
 
LVL 1

Author Comment

by:donebert
ID: 40328585
Here is what sql query shows
sql-drive-map-error.docx
0
 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 40328669
That is exactly what I was referring to. If you run the same command in OS prompt window it waits for your answer for the "want to override the rememberred connection?( Y/N)" question, which you can't provide with xm_cmdshell. If you run it in windows you can type Y/N, depending on what you want.

If you want to default to Yes very time you can try to add

/p:yes

to your command executed by xp_cmdshell.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question