Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

auto moving files

  • 21-09-2009 11:28am
    #1
    uch
    Registered Users, Registered Users 2 Posts: 7,020 ✭✭✭


    Lads I need to copy a sql backup file to a Remote server after it has run and delete it locally then, any ideas if there are any apps that can do this or is there any script I can use?

    21/25



Comments

  • #2
    francosp
    Registered Users, Registered Users 2 Posts: 355 ✭✭francosp


    uch wrote: »
    Lads I need to copy a sql backup file to a Remote server after it has run and delete it locally then, any ideas if there are any apps that can do this or is there any script I can use?

    I assume you are on some sort of Unix machine ?

    If you are then you can use rsync, ssh or ftp/sftp, via cron to achieve this.

    More details would be nice.


  • #3
    uch
    Registered Users, Registered Users 2 Posts: 7,020 ✭✭✭uch


    Nah they are virtual windows servers, sql does'nt seem to want to give me the option to save the .bak files to a mapped drive, so I need some way o0f shipping them off to a network location

    21/25



  • #4
    francosp
    Registered Users, Registered Users 2 Posts: 355 ✭✭francosp


    uch wrote: »
    Nah they are virtual windows servers, sql does'nt seem to want to give me the option to save the .bak files to a mapped drive, so I need some way o0f shipping them off to a network location

    UUgh, Windohs is not my speciality but surely you could write a bat script to move/copy them to the networked drive ?

    Have a look here..

    http://tinyurl.com/l6bfkm


  • #5
    uch
    Registered Users, Registered Users 2 Posts: 7,020 ✭✭✭uch


    francosp wrote: »

    Have a look here..

    http://tinyurl.com/l6bfkm


    Great thanks for the help, got it working now with xCopy

    Thanks again

    21/25



  • #6
    BaconZombie
    Registered Users, Registered Users 2 Posts: 8,813 ✭✭✭BaconZombie


    If this a VM why not shutdown the old system and just mount it's HD on the new VM?


  • Advertisement
Advertisement