Post reply

copying backup files to a different network

  • October 31, 2013 at 5:07 am

    #281873

    Hi

    I have a requirement to copy the live production backups to the dev environment. The networks are on totally different domains/ip ranges etc. Currently I am manually copying and pasting by opening Remote Desktop Connection Manager, connecting to a live server, selecting the backup file and then pasting this file to new location via my rdp session. This is taking an extremely long time and I was wondering is there something else i could do to make this task easier - I have seen some articles suggestion using powershell but I am unsure as the articles don't seem to explain how the connection would work.

    I have posted this on here as it is an sql server backup file I wish to copy and I am hoping that somebody else has had a similar dilemma as I can imagine this is not a uncommon situation.

  • October 31, 2013 at 5:29 am

    #1662994

    Powershell is the way to go.

    I posted a similar script on my blog. You can find it here[/url].

    If something is unclear to you, feel free to ask.

    Hope this helps

    -- Gianluca Sartori

  • October 31, 2013 at 5:38 am

    #1662999

    Do you have the link to the required article ?

    Many thanks

  • October 31, 2013 at 5:43 am

    #1663000

    spaghettidba (10/31/2013)

    Powershell is the way to go.

    I posted a similar script on my blog. You can find it here[/url].

    If something is unclear to you, feel free to ask.

    Hope this helps

    Actually you already had the link in my previous post.

    Hyperlinks are not very visible and I should have highlighted with some bold as I usually do.

    Here's the URL anyway:

    http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/

    -- Gianluca Sartori

  • October 31, 2013 at 6:15 am

    #1663017

    Hi

    Thanks for the link first of all.

    I am not sure I fully understand reading through the script though as I have never used powershell.

    I am just trying to copy a backup file from one server to the other - not transaction log files.

    How is the connection made between a server say on an ip of 10.158.20.5 to another on 10.2.10.1 (they are not the exact ip's but you get my point !)

    There seems to be a lot going on in that script and i'm not sure which bits I would need to follow/copy.

    Apologies for my limited understanding on this !

    🙂

  • October 31, 2013 at 10:56 am

    #1663190

    The two servers should be able to communicate via SMB (shared folder), FTP or any other method.

    In my script SMB is used.

    -- Gianluca Sartori

  • October 31, 2013 at 11:10 am

    #1663200

    I modified my script for you.

    Here it is: http://spaghettidba.com/2013/10/31/copy-user-databases-to-a-different-server-with-powershell/

    -- Gianluca Sartori

  • October 31, 2013 at 12:29 pm

    #1663226

    There are numerous scripts on this site. Search for copy backup files in the bar above.

  • October 31, 2013 at 3:28 pm

    #1663282

    thank you very much for this. I will have to read up about powershell as i know little about it. I will have to understand the script fully before i try and run it on a production/dev environment

    Thanks once again

Viewing 9 posts - 1 through 9 (of 9 total)

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