MSDB Size

  • Hello.

    Reading about MSDB growth and understand that this issue usually gets put down to
    tables with millions of rows relating to Backup Files and their History etc.What I see
    is @ 500K rows in our tables.
    Far and away the largest tables are the log_shipping_monitor tables and Indexes.

    Does anybody perform maintenance on these tables, and if so how, or do most folks
    just let MSDB grow these days with Indexes on these tables?

    Regards
    Steve O.

  • Yes perform maintenance keep history within your backup strategy. That means deleting history.

    ...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply