Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IDontExist
Starting Member
3 Posts |
 Posted - 2010-08-09 : 12:29:27
|
| I'm stumped by this, hoping someone can help:I just installed two new default instances of R2, and when I go into a DB's properties to set up log shipping, there is no option for compression. I have 2008 developer edition in a lab, so I see where it should be (in between the schedule section and the note at the bottom), but there's nothing there - just like it would've been pre-R2 or in 2005.Thanks!(and yes, I did just sign up to ask this - long time lurker, first time poster) |
|
|
IDontExist
Starting Member
3 Posts |
Posted - 2010-08-11 : 09:02:35
|
| Could someone at least confirm that they're able to see the compression option in their log shipping wizard?Also, the log_shipping_primary_databases table DOES have the backup_compression column, so I believe I can make the change manually, but I haven't tested that yet. |
 |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-08-31 : 15:51:15
|
| Hello,In SQL 2008 R2 Standard I do not see the compression. May be looking in the wrong place though.djj |
|
|
|
|
|
|
log shipping missing compression option