These guidelines offer comprehensive assistance for mapping a network drive on a server, and the advantages extend to both local and remote work scenarios. A mapped network drive serves as a virtual representation of a network resource, encompassing shared folders or network-attached storage, seamlessly integrating them with your computer.
Below are the steps on how to configure.
1. Start by selecting 'This PC' on your server.
2. Navigate to the 'Computer' tab and choose 'Map Network Drive' from the options.
3. In the 'Drive' list, select an available drive letter.
4. In the 'Map Network Drive' window, click 'Browse' to locate the desired network folder or computer.
5. Once you've made your selection, click 'Finish' to complete the mapping process."
6. 1st script to run on SQL
EXEC sp_configure 'show advanced options',1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO
7. 2nd script to run on SQL
EXEC xp_cmdshell 'NET USE Z: "\\WIN2008SVR\Autobackup" P@ssw0rd
/USER:Administrator\Administrator'
Reminder:
· Letter Z - This is the letter for the mapped network drive
· \\WIN2008SVR\Autobackup - This is the shared name, or the path, for the 'autobackup' folder located within drive Z.
· P@ssw0rd - Password of the Server
· Administrator - The user who is logged in to SQL Management Studio.
· Administrator - The user who is actively using to log in to the server.