{"id":1168,"date":"2021-08-17T06:20:48","date_gmt":"2021-08-17T06:20:48","guid":{"rendered":"https:\/\/datarebus.com\/?p=1168"},"modified":"2021-08-17T06:21:29","modified_gmt":"2021-08-17T06:21:29","slug":"make-network-path-visible-for-sql-server-backup-and-restore-in-ssms","status":"publish","type":"post","link":"https:\/\/datarebus.com\/index.php\/2021\/08\/17\/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms\/","title":{"rendered":"Make Network Path Visible For SQL Server Backup and Restore in SSMS"},"content":{"rendered":"\n<p>You want to backup or restore a database but you cannot see the Drive letter even you had mapped fromo operating system. <\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img src=\"https:\/\/www.mssqltips.com\/tipimages2\/3499_Restore%20Options%20Before.gif\" alt=\"Make Network Path Visible For SQL Server Backup and Restore\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>you should follow these steps:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul><li>MAP YOUR DRIVE<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img src=\"https:\/\/www.mssqltips.com\/tipimages2\/3499_Map%20Drive.gif\" alt=\"Map Network Drive\"\/><\/figure>\n\n\n\n<ul><li>OPEN YOUR XP_CMDSHELL OPTION<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"329\" height=\"177\" src=\"https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image.png\" alt=\"\" class=\"wp-image-1169\" srcset=\"https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image.png 329w, https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image-300x161.png 300w\" sizes=\"(max-width: 329px) 100vw, 329px\" \/><\/figure>\n\n\n\n<ul><li>DEFINE YOUR MAPPED DRIVE TO YOUR SQL SERVER<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"426\" height=\"28\" src=\"https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image-1.png\" alt=\"\" class=\"wp-image-1170\" srcset=\"https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image-1.png 426w, https:\/\/datarebus.com\/wp-content\/uploads\/2021\/08\/image-1-300x20.png 300w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/figure>\n\n\n\n<ul><li>TEST IT<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img\/><\/figure>\n\n\n\n<p>Now, you can browse your mapped drive from SSMS and perform your backup\/restore directly.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[12,7,20,18],"_links":{"self":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1168"}],"collection":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/comments?post=1168"}],"version-history":[{"count":1,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1168\/revisions"}],"predecessor-version":[{"id":1171,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1168\/revisions\/1171"}],"wp:attachment":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media?parent=1168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/categories?post=1168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/tags?post=1168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}