Showing network mapped drive in SQL Restore Database

 EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'xp_cmdshell',1

GO

RECONFIGURE

GO

EXEC XP_CMDSHELL 'net use H: \\192.172.0.141\Downloads /User:username password '

You need /User if your shared drive requires authentication. Once this is done, You should be able to see H drive whle restoring the database.