• GilaMonster (4/25/2012)


    How can you do an index defrag of a log shipping secondary? It's read-only at best. Or do you mean index rebuild on the primary and log shipping copied that over? If the latter caused that error on the secondary, there's something wrong with that DB or server.

    are you having a senior moment ? 😛

    i defragged the indexes on the primary (or shipper) and when the log is copied across the same changes are applied to the secondary (or shipee)

    MVDBA