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

SQL Backup performance vs Native Backup

Hi, Can I work with someone please to discover if we can fix SQL backup or at least understand why it takes 19 hours for SQL Backup vs 4 hours 40 mins with a native backup.
brentm
0

Comments

3 comments

Sort by
  • Dan B
    Hi brentm,

    Thanks for posting on the Redgate forums.

    In the first instance can you run through the optimization script from https://documentation.red-gate.com/sbu9/troubleshooting/optimizing-backup-speed, which will ensure everything is configured correctly.

    From there we can further investigate this discrepancy. 

    Is the backup being copied to a local or a remote disk?
    Dan B
    0
  • brentm
    Yes the backup is configured properly. I have had to reduce the number of files as it was MAX'ing out the CPU. Currently set for 8. I have included the buffercount option. 
    The database in question has filestream and so I think this is the issue that SQL Backup can't handle.
    the final backup file is about the same size as the native backup so I'm not concerned about compression - it is set at level 2.
    brentm
    0
  • Dan B
    Hi Brentm,

    Is it possible to get a log file from SQL Backup for one of the jobs taking 19 hours? I will create a support ticket and send you an email you can reply too with this information.
    Dan B
    0

Add comment

Please sign in to leave a comment.