Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Compression Option not found while confguring Log Shipping

Answered Compression Option not found while confguring Log Shipping

  • Sunday, March 17, 2013 12:19 PM
     
     
    Sign In to Vote
    0

    Hi All,

    I am using Microsoft SQL server 2008 R2 Standard Edition and as per Microsoft edition comparison Std 2008R2 having the ability of Data Compression.

    At the time of Log Shipping configuration there is no options for Set Backup Compression :-(

    what to do please help!

    Thanks

     

All Replies

  • Sunday, March 17, 2013 9:04 PM
     
     
    Sign In to Vote
    0
    I can see that option here...but this is on sql 2008 enterprise edition...sql2008R2 standard edition should also have the same option...do not you see like this??

    Hope it Helps!!

     
  • Monday, March 18, 2013 3:41 AM
     
     
    Sign In to Vote
    0
    No the option is not there............
     
  • Monday, March 18, 2013 4:39 AM
     
     Answered Has Code
    Sign In to Vote
    0
    No the option is not there............

    Looks like UI does not have the option but after doing the intial set up, you can script out the entire log shipping set up and then add this to the 
    ,@backup_compression = 1

    to this step  in the code...(add the above parameter to this part of the code..) 
    Exec @sp_retCode = master.dbo.sp_add_log_shipping_primary_database

    Hope it Helps!!