So I've been poking around one of the databases and as part of my ongoing health checks, I reviewed the VLF numbers with a quick DBCC LOGINFO.
This particular database has 628... *sigh*
So I start to look to rebuild this, and when I take my log backup, it gives me a warning that there are replication publications on this.
Now in this case, the subscriber replication agent pops up once or twice a day and pulls everything across. And to complicate things, there are 2 subscribers.
So I'm looking for suggestions on how I can rebuild this log file to reduce the number of VLFs without breaking the subscriptions and causing huge amounts of pain.
Suggestions? Or do I just leave it alone. Performance is acceptable, so this is, in part, optimisation for the sake of optimising.