Categories:

You want to backup or restore a database but you cannot see the Drive letter even you had mapped fromo operating system.

Make Network Path Visible For SQL Server Backup and Restore

you should follow these steps:

  • MAP YOUR DRIVE
Map Network 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

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.