deleted a SQL table of 350 GB, cut compression from 4 to 2 and still no reduction in backup time?

cbirckhead

I truncated, then deleted a large table of approximately 350 GB and saw absolutely no reduction in my backup time. I also cut my compression level from 4 to 2 and again... saw no reduction in backup time. My backup is taking over 12 hours!!!
Total DB is 4 TB.

Pete_Ruiz

Hi Chip,

What version of SQL Backup are you using? If not already, can you please confirm if the performance issues exist on the latest version of SQL Backup?

Can you please provide additional details about your source and target environments?

Also, here a few suggestions on how you can optimize the backup speeds: https://documentation.red-gate.com/sbu10/troubleshooting/optimizing-backup-speed

Lastly, can you please send over the log files? https://documentation.red-gate.com/sbu10/troubleshooting/sql-backup-log-files