I'm log shipping a couple of dozen databases from 3 live servers onto a single standby server. The transaction log files disk on the standby server is getting pretty full so I need to do something. There's a lot of unused space in some of these log files (which are matching sizes on live and standby). Some of them are only that big because of major refactoring excercises, and don't need to be that big normally, so I reckon I can shrink them on the live server. But will that action get shipped over and repeated on the standby? Somehow I doubt it.
The standby databases are in Standby / Read-Only mode. Can you suggest a way I can shrink the logs on both live and standby without breaking the log shipping cycle, please?