Mapping a Network Drive in SQL Management Studio for Backups

Just follow these steps from our Tech Support Team Open SQL Management Studio and “New Query” You only need to do this bit once: EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'xp_cmdshell',1 GO RECONFIGURE GO Now define that share drive for SQL with the xp_cmdshell command as follows: Changing H to whatever drive you require EXEC XP_CMDSHELL 'net use H: \RemoteServerNameShareName /USER:domainusername Passw0rd1' It should now be mapped. In order to verify the new drive, you can use the below command that will show you all files in that newly mapped drive: EXEC XP_CMDSHELL 'Dir H:'
Last updated on 3 Dec 2020
500 reads
Tell us what you think?10