x

Robocopy ERROR : No Destination Directory Specified.

Hi ,

I am trying to copy the file using Robocopy in SQL.

It give me following message:-

 NULL
 -------------------------------------------------------------------------------
    ROBOCOPY     ::     Robust File Copy for Windows     ::     Version XP010
 -------------------------------------------------------------------------------
 NULL
   Started : Fri Oct 08 16:45:59 2010
 NULL
    Source :  \\hsbc-bsc1\ggg 
      Dest - 
 NULL
     Files : *.*
      
   Options : *.* /COPY:DAT /R:1000000 /W:30 
 NULL
 ------------------------------------------------------------------------------
 NULL
 ERROR : No Destination Directory Specified.
 NULL
        Simple Usage :: ROBOCOPY source destination /MIR
 NULL
              source :: Source Directory (drive:\path or \\server\share\path).
         destination :: Destination Dir  (drive:\path or \\server\share\path).
                /MIR :: Mirror a complete directory tree.
 NULL
     For more usage information run ROBOCOPY /? or read Robocopy.Doc.
 NULL
 NOTE: Read "True Replication" in Robocopy.Doc prior to first use of /MIR !
 ****  /MIR can DELETE files as well as copy them !
 NULL

But when i run using XP_cmdshell it work fine.

Actullly it is not identifying my Destination folder where i want to copy .

Pls help.

The feild Dest - is empty.

more ▼

asked Oct 08, 2010 at 04:24 AM in Default

avatar image

mandara
39 10 10 11

Given that both @Matt and I are coming at this from different sides, perhaps if you told us what you're trying to achieve (SQL Server commands, version of SQL Server etc), then we might be able to help more effectively!

Oct 08, 2010 at 04:55 AM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

Sounds like a permissions error - does the userID that's running the job have access to the directory?

more ▼

answered Oct 08, 2010 at 04:41 AM

avatar image

ThomasRushton ♦♦
42k 20 51 53

(comments are locked)
10|1200 characters needed characters left

I would guess that this is an issue to do with QUOTED_IDENTIFIER - but really, given that you have just put in the error message and not any detail about what you are trying to run, I'm a bit lost for suggestions.

more ▼

answered Oct 08, 2010 at 04:54 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left

Have you tried specifying a destination directory?

more ▼

answered Oct 08, 2010 at 05:16 AM

avatar image

Fatherjack ♦♦
43.8k 79 99 118

(comments are locked)
10|1200 characters needed characters left

Please post the actual robocopy command you have used. There are a multitude of switches and parsing this via T-SQL can be tricky.

more ▼

answered Oct 08, 2010 at 06:17 AM

avatar image

Blackhawk-17
12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

HI,

I HAVE A SIMILAR ISSUE IM TRYING TO INSTALL WINDOWS 7 FROM USB: HELP STUCK AT THIS PART...

DiskPart marked the current partition as active.

DISKPART> FORMAT FS = NTFS QUICK

100 percent completed

DiskPart successfully formatted the volume.

DISKPART> ASSIGN

DiskPart successfully assigned the drive letter or mount point.

DISKPART> EXIT

Leaving DiskPart... PS C:\WINDOWS\system32> ROBOCOPY D:\E:\/MIR


ROBOCOPY :: Robust File Copy for Windows

Started : October 21, 2017 10:47:50 AM Source : D:\E:\MIR\ Dest -

 Files : *.*

Options : . /DCOPY:DA /COPY:DAT /R:1000000 /W:30


ERROR : No Destination Directory Specified.

    Simple Usage :: ROBOCOPY source destination /MIR

          source :: Source Directory (drive:\path or \\server\share\path).
     destination :: Destination Dir  (drive:\path or \\server\share\path).
            /MIR :: Mirror a complete directory tree.

 For more usage information run ROBOCOPY /?


/MIR can DELETE files as well as copy them ! PS C:\WINDOWS\system32> ROBOCOPY


ROBOCOPY :: Robust File Copy for Windows

Started : October 21, 2017 10:48:12 AM Simple Usage :: ROBOCOPY source destination /MIR

          source :: Source Directory (drive:\path or \\server\share\path).
     destination :: Destination Dir  (drive:\path or \\server\share\path).
            /MIR :: Mirror a complete directory tree.

 For more usage information run ROBOCOPY /?


/MIR can DELETE files as well as copy them ! PS C:\WINDOWS\system32> ROBOCOPY D:\E:\/MIR::MIRROR/MIR :: MIRror a directory tree (equivalent to /E plus /PURGE). equivalent : The term 'equivalent' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:61 + ... D:\E:\/MIR::MIRROR/MIR :: MIRror a directory tree (equivalent to /E p ... + ~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (equivalent:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException

PS C:\WINDOWS\system32> ROBOCOPY D:\E:\/MIR::MIRROR/MIR :: MIRror a directory tree to /H plus /PURGE


ROBOCOPY :: Robust File Copy for Windows

Started : October 21, 2017 10:50:40 AM Source - D:\E:\MIR::MIRROR\MIR\ Dest - ::\

 Files : MIRror
         a
         directory
         tree
         to

Options : /DCOPY:DA /COPY:DAT /R:1000000 /W:30


ERROR : Invalid Parameter #8 : "/H"

    Simple Usage :: ROBOCOPY source destination /MIR

          source :: Source Directory (drive:\path or \\server\share\path).
     destination :: Destination Dir  (drive:\path or \\server\share\path).
            /MIR :: Mirror a complete directory tree.

 For more usage information run ROBOCOPY /?


/MIR can DELETE files as well as copy them ! PS C:\WINDOWS\system32> /MIR::MIRROR /MIR::MIRROR : The term '/MIR::MIRROR' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + /MIR::MIRROR + ~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (/MIR::MIRROR:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException

PS C:\WINDOWS\system32> ROBOCOPY D:\E:\/MIR::MIRROR/MIR :: F /PURGE


ROBOCOPY :: Robust File Copy for Windows

Started : October 21, 2017 10:53:24 AM 2017/10/21 10:53:24 ERROR 3 (0x00000003) Getting File System Type of Destination ::\ The system cannot find the path specified.

Source : D:\E:\MIR::MIRROR\MIR\ Dest - ::\

 Files : F

Options : /DCOPY:DA /COPY:DAT /PURGE /R:1000000 /W:30


2017/10/21 10:53:24 ERROR 123 (0x0000007B) Accessing Source Directory D:\E:\MIR::MIRROR\MIR\ The filename, directory name, or volume label syntax is incorrect. PS C:\WINDOWS\system32> ROBOCOPY F:\E:\MIR::MIRROR/F:/PURGE


ROBOCOPY :: Robust File Copy for Windows

Started : October 21, 2017 10:55:08 AM Source = F:\E:\MIR::MIRROR\F:\PURGE\ Dest -

 Files : *.*

Options : . /DCOPY:DA /COPY:DAT /R:1000000 /W:30


ERROR : No Destination Directory Specified.

    Simple Usage :: ROBOCOPY source destination /MIR

          source :: Source Directory (drive:\path or \\server\share\path).
     destination :: Destination Dir  (drive:\path or \\server\share\path).
            /MIR :: Mirror a complete directory tree.

 For more usage information run ROBOCOPY /?


/MIR can DELETE files as well as copy them !

USING TEMPLATE AT http://crashmag.net/creating-a-bootable-usb-to-install-windows-7-or-windows-server-2008-r2

more ▼

answered Oct 21 at 08:02 PM

avatar image

JESSICA327
1

It looks as though you're missing a space between D:\ and E:...

Oct 21 at 08:40 PM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x27

asked: Oct 08, 2010 at 04:24 AM

Seen: 5051 times

Last Updated: Oct 21 at 08:40 PM

Copyright 2017 Redgate Software. Privacy Policy