Re: How do I copy a file using xp_cmdshell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 02/11/05


Date: Fri, 11 Feb 2005 14:46:56 -0000

D:\ultradb\ Log_data.mdb

There ^ to be exact :)

-- 
Jacco Schalkwijk
SQL Server MVP
"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote 
in message news:eKOmhcEEFHA.3032@TK2MSFTNGP12.phx.gbl...
>\ L
>
> There's a space between the \ and the L.
>
> -- 
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Vincel2k2" <Vincel2k2@discussions.microsoft.com> wrote in message 
> news:62257A3D-CCF8-46B7-9A6F-65399CF61FD6@microsoft.com...
>> 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
>>
>
> 


Relevant Pages

  • Re: File Deletion Guidence
    ... >You need double quotes around filename with spaces in ... >Jacco Schalkwijk ... >SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I copy a file using xp_cmdshell
    ... SQL Server MVP ... "Vincel2k2" wrote in message ... The network name cannot be found. ...
    (microsoft.public.sqlserver.programming)
  • Re: Various Errors connecting to SQL 200 Server
    ... Have you tried connecting to the server by IP address instead of the ... Jacco Schalkwijk ... SQL Server MVP ... >> From the error messages you posted it looks to me like there is a network ...
    (microsoft.public.sqlserver.connect)
  • Re: NULL Records
    ... I don't think that the fact that your column is named KEY is the cause of ... Jacco Schalkwijk ... >> SQL Server MVP ... >>>>> error saying KEY Column information is insufficient or incomplete. ...
    (microsoft.public.sqlserver.server)
  • Re: How can I control execution wait time within a stored procedure?
    ... "Ken Sturgeon" wrote in message ... Any pointers you might have to articles, ... > "Jacco Schalkwijk" ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)