Suggestion for multiple backup location.

• Steve Velasco

  Old Hand

  Points: 332

  More actions

  October 2, 2006 at 3:07 pm

  #114473

  Hello folks,

  Problem: Currently I have backup dumps on local disk and nightly these backups are copied to tape. I would like to multiplex my backup meaning create another copy onto another location aside from the local disk. I don't see this option on the maitenance plan.

  Possible solutions: Create a SP or operating system script to copy the backup files to another location.

  Anyone currently performing this task? I'd love to hear your current process.

  Thanks,

  SteveV

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  October 3, 2006 at 8:36 am

  #663846

  http://support.microsoft.com/?kbid=555128

  http://msdn2.microsoft.com/en-us/library/ms179313.aspx

  i hope this will help.

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  October 3, 2006 at 6:43 pm

  #663987

  A simple approach would be to use xp_cmdshell 'copy ...' command to copy the backup file (when the full backup is done) to an alternate location.