How do I copy a file using xp_cmdshell

From: Vincel2k2 (Vincel2k2_at_discussions.microsoft.com)
Date: 02/11/05


Date: Fri, 11 Feb 2005 06:29:02 -0800

Things I have tried.

xp_cmdshell "Copy D:\Database\Apps\Ven.mdb D:\ultradb\Ven.mdb"
This Works Great

xp_cmdshell "Copy X:\MMS\Data1\Log_data.mdb D:\ultradb\ Log_data.mdb"
Returns this error: The network name cannot be found. The path and filename
are correct

xp_cmdshell "Copy \\SERVER01\DATA\SHARED\WORK\MMS\Data1\ Log_data.mdb
D:\ultradb\ Log_data.mdb"
Returns this error: The network name cannot be found. The path and filename
are correct

EXEC xp_cmdshell ‘Copy \\SERVER01\DATA\SHARED\WORK\MMS\Data1\ Log_data.mdb
D:\ultradb\ Log_data.mdb
Returns this error: The network name cannot be found. The path and filename
are correct