I was running out of diskspace and had a databaes .bak file at UNC to restore locally, if I copy that then won't left with enough disk space to restore that as well. When I mapped the shared folder to local drive and tried to restore database I couldn't see mapped drive nor was I able to use share path as is
Reason: SQL management studio run under a different session.
Resolution: In order to use share folder path go to the remote computer and share that folder with everyone (or find which account SQL management studio is running and share it with that account). Then on SQL MS go to restore database option then disk option and click add and then paste the share path in the folder path and in the file name enter the .bak file name and click OK though SQLMS won't show shared drive it will accept the share folder path.
https://blogs.msdn.microsoft.com/sql_scratchpad/2014/03/11/restore-database-from-a-unc-path-why-ssms-doesnt-show-network-drivespaths-in-the-restore-wizard/
Reason: SQL management studio run under a different session.
Resolution: In order to use share folder path go to the remote computer and share that folder with everyone (or find which account SQL management studio is running and share it with that account). Then on SQL MS go to restore database option then disk option and click add and then paste the share path in the folder path and in the file name enter the .bak file name and click OK though SQLMS won't show shared drive it will accept the share folder path.
https://blogs.msdn.microsoft.com/sql_scratchpad/2014/03/11/restore-database-from-a-unc-path-why-ssms-doesnt-show-network-drivespaths-in-the-restore-wizard/
No comments:
Post a Comment