Hello I have a primary/secondary log shipping pair and the the size of the database is getting too large. Because of other constraints I cannot shrink the live database. I intend to archive data off the standby, and then shrink the standby and then make this the primary, creating a new standby as part of starting the log shipping process. Can anyone see any issues with this? Will I have to stop applying logfiles to the secondary while I shrink? Can I then resume log shipping? Or does shrinking wreck the log shipping process? Thanks everyone!