Enabling compression for LS backup job in SQL Server 2008 R2 standard


  • Hi,

    In a log shipping set up in SQL SErver 2008 R2, I noticed that backup compression is enable for full backup job for the database. But LS backup job is not compression log backups. Because of this the LS trn backup is much bigger than the database full backup. Is there a way by which we can enable this setting without reconfiguring log shipping all over again.

    I saw in log shipping properties etc. but couldn't find any. Please suggest.


    Wednesday, August 21, 2013 10:08 PM


All replies