Post reply

robocopy and named instances

  • July 8, 2015 at 7:51 am

    #398715

    Hi

    I am using robocopy to copy my sql server backups to a fileshare. This is working great except for named instances.

    I use Ola Hallegren's backups which create a folder called xxxx$xxxx. Robocopy can't seem to handle the $. Does anyone know of a solution?

    Thanks

    Kathy

  • July 8, 2015 at 8:18 am

    #1810967

    Are your backups large enough you actually need to use a non standard windows command to move them?

  • July 8, 2015 at 8:27 am

    #1810971

    I guess I don't understand the question. Would you elaborate please?

    Thanks

    Kathy

  • July 8, 2015 at 8:31 am

    #1810974

    Have you tried mounting the folder to the root of a new drive letter?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • July 8, 2015 at 8:35 am

    #1810976

    Well is there a reason you need to use robocopy instead of just the standard move command?

  • July 8, 2015 at 8:36 am

    #1810978

    No I haven't tried that yet. I was first looking for a syntactical solution -- if possible.

  • July 8, 2015 at 8:40 am

    #1810981

    No real solid reason for using robocopy vs. move. I have a powershell script that runs robocopy from sql server agent. So right after the agent executes Ola's backup then next step is to copy the backup to a fileshare.

    Thanks

    Kathy

  • July 8, 2015 at 8:43 am

    #1810986

    i also use robocopy to copy files out to an additional network location; i like the fact that it is smart enough to only move files that changed.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 8, 2015 at 10:05 am

    #1811034

    kathy.plamann (7/8/2015)

    I have a powershell script that runs robocopy from sql server agent

    Cut out the middleman and just use PoSh to copy the files instead of Robocopy 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 8, 2015 at 10:22 am

    #1811042

    kathy.plamann (7/8/2015)

    Hi

    I am using robocopy to copy my sql server backups to a fileshare. This is working great except for named instances.

    I use Ola Hallegren's backups which create a folder called xxxx$xxxx. Robocopy can't seem to handle the $. Does anyone know of a solution?

    Thanks

    Kathy

    I'm a big fan of robocopy, and just tried with a source directory name containing a '$', and again with the destination directory name containing a '$', successful both times. Are we sure thats the issue?

  • July 8, 2015 at 10:23 am

    #1811044

    Perry Whittle (7/8/2015)

    kathy.plamann (7/8/2015)

    I have a powershell script that runs robocopy from sql server agent

    Cut out the middleman and just use PoSh to copy the files instead of Robocopy 😉

    whats the syntax in PoSh to set interpacket gaps?

  • July 8, 2015 at 11:21 am

    #1811064

    Did you try enclosing path in double quotes?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • July 9, 2015 at 3:11 am

    #1811217

    patrickmcginnis59 10839 (7/8/2015)whats the syntax in PoSh to set interpacket gaps?

    Would it really be that much of an issue?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 9, 2015 at 4:16 am

    #1811228

    Perry Whittle (7/9/2015)

    patrickmcginnis59 10839 (7/8/2015)whats the syntax in PoSh to set interpacket gaps?

    Would it really be that much of an issue?

    That's true, I don't have to have that functionality in a copy operation, as long as there was some other way to manage the bandwidth that the copy operation consumes. But having that functionality in robocopy sure is handy!

  • July 9, 2015 at 5:01 am

    #1811236

    patrickmcginnis59 10839 (7/9/2015)

    That's true, I don't have to have that functionality in a copy operation, as long as there was some other way to manage the bandwidth that the copy operation consumes. But having that functionality in robocopy sure is handy!

    Begs the question, what on earth are you doing that makes that much of an impact to require packet control?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 1 through 15 (of 33 total)

You must be logged in to reply to this topic. Login to reply