You want to backup or restore a database but you cannot see the Drive letter even you had mapped fromo operating system.
you should follow these steps:
- MAP YOUR DRIVE
- OPEN YOUR XP_CMDSHELL OPTION
- DEFINE YOUR MAPPED DRIVE TO YOUR SQL SERVER
- TEST IT
Now, you can browse your mapped drive from SSMS and perform your backup/restore directly.
No responses yet