Multiple Network Shares

• 
  Use multiple COPYTO switches e.g.
  

  EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [<AUTO>] WITH COPYTO = [\share01sqlbackups<DATABASE>], COPYTO = [\share02sqlbackups<DATABASE>], COPYTO = [\share03sqlbackups<DATABASE>] " '
  

  Note that the backup only completes when the file(s) have been copied to all your COPYTO destinations, and will require a longer backup window. For transaction log backups, the files are copied by a separate process, so the backup completes without waiting for the files to be copied.

  petey April 23, 2015 20:53

  - 0 +
• 
  That's perfect, thank you so much.

  JoshDBGuy April 27, 2015 15:29

  - 0 +

Add comment

Please sign in to leave a comment.