question

mandara avatar image
mandara asked

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.
xp_cmdshell
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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!
1 Like 1 ·
ThomasRushton avatar image
ThomasRushton answered
Sounds like a permissions error - does the userID that's running the job have access to the directory?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
Have you tried specifying a destination directory?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered
Please post the actual robocopy command you have used. There are a multitude of switches and parsing this via T-SQL can be tricky.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JESSICA327 avatar image
JESSICA327 answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.