What are the challenges you face when working across database platforms? Take the survey
Options

SQL Backup - MSSQL "Compress Backup" Option?

bbcolo22bbcolo22 Posts: 2
edited April 25, 2016 10:22AM in SQL Backup Previous Versions
Hello everyone,

Would it hurt anything to set the MSSQL Engine "Compress Backups" option to TRUE for an instance that uses RedGate Backup Pro?

I do realize that your tool also does compression, but I just want to make sure that it won't hurt anything to have this set.

Thanks,
Bill

Comments

  • Options
    Hi bbcolo22,

    Turning on Compress Backups within SSMS won't affect SQL Backup at all. Compress backups only have any effect when the backup is taken and so operates outside of SQL Backup.

    Having said that if you do get any problems please do let me know.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.