How can we help you today? How can we help you today?

Splitting Up Backup and Copy Functions

Is there a way to split up the backup and copy functions using Redgate? I can do backups myself and then use SQL/Powershell to do copies to network locations but I'd rather use redgate. Is this possible?
JoshDBGuy
0

Comments

3 comments

Sort by
  • petey
    What is the reason for wanting to split the backup and copy functions?
    petey
    0
  • rayherring
    I would also like to have the backup and copy in two steps.
    I have a number of production jobs that I have to disable prior to starting the Full Backup. I have to do this because the disk I/O contention on the data drives was significantly slowing both production processing and backup throughput. The Full Backup was taking > 24 hours. With Jobs disabled it now takes 3 - 4 hours.
    As soon as the Full Backup is completed the Production Jobs can be restarted.
    The file copy to off-storage can then run without impact.

    Currently I have separate Backup job steps to
      Disable Selected Production Jobs Run Backup Enable Selected Production Jobs Copy Backups to File Server (Power Shell)
    rayherring
    0
  • petey
    There is an option to place the backup file(s) to be copied into a separate process, so that the backup job completes as soon as the database backup has completed. However, the queued copy process will be picked up a minute or two later, thus you have no control over the exact time the copying is performed.

    To enable this option, use the USEQUEUEDCOPY keyword e.g.

    EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO ... WITH COPYTO = ..., USEQUEUEDCOPY"'
    petey
    0

Add comment

Please sign in to leave a comment.