Post reply

Moving/placing backups in another server

  • October 12, 2011 at 4:45 am

    #244562

    hi,

    How we can provide the another server physical location for backups in maintenance plans as I want to place/save the backups in another server

    Is there any third party tool to move backups from one server to another server ?

    Thanks and Regards,

    Ravi.

  • October 12, 2011 at 6:17 am

    #1393365

    Not exactly what you're asking for, but could be a starting point: http://sqlbackupandftp.com/

    -- Gianluca Sartori

  • October 12, 2011 at 8:17 am

    #1393478

    A simple DOS batch job can create a backup of your database and copy your backups to other server locations. But I am not sure whether you can call it in your maintenance plans.

    How to schedule SQL Server backup or DBCC commands by using AT scheduler command

    http://support.microsoft.com/kb/162294

  • October 12, 2011 at 11:25 pm

    #1393796

    Thank you all for your valid replies !!

    My Question is...

    How we can schedule to copy/move backups from one server to another server?

    For this is there any script available or thirdparty available ??

    Please advice.

    Thanks and Regards,

    Ravi.

  • October 12, 2011 at 11:49 pm

    #1393800

    you can use xp_cmdshell to create a copy script and schedule to run.

    xp_cmdshell 'copy d:\backups\*.* \\remoteserver\backups\'

  • October 13, 2011 at 3:05 am

    #1393875

    Thanks for your reply !!

    Can we automate to copy backups from one server to another server by using Copy Command in Jobs ?

    But when job runs next time only latest backups should be copied/moved to destination server.

    Please advice.

    Thanks and Regards,

    Ravi.

  • October 13, 2011 at 5:14 am

    #1393924

    Ravi

    Have a look Roshan's script: To find latest backups for all databases[/url].

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • October 13, 2011 at 5:37 am

    #1393942

    How about creating a share on the 2nd server and backing upto that location ?

    You could also look into creating an SSIS package.

    Cheers

    Vultar

  • October 13, 2011 at 5:57 am

    #1393949

    You could also look into creating an SSIS package

    OP has stated that he already tried Maintenance Plans which has a subset of SSIS tasks specific to database maintenance e.g. backup, index re-build etc.

    Once backups are generated, it can be moved by DOS commands (easiest, cheapest and classic way).

  • October 13, 2011 at 8:24 am

    #1394074

    OP has stated that he already tried Maintenance Plans which has a subset of SSIS tasks specific to database maintenance e.g. backup, index re-build etc.

    My point was that you could build an SSIS package to perform the backups and then copy the files to the new location, not use maintenance plans. You could do this by using the 'File System Task' feature or put a .bat or xp_cmdshell in task.

    Cheers

    Vultar

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

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