• Thanks Jeff for keeping it up.

    🙂

    Your list of suggested action is perfect, but I'd say it's a bit overkill for beginners.

    To start - it's important to remember doing regular LOG backups apart from DB backups.

    Then after the pattern of TRN usage over day/week is established then shrink TRN file to the apprpriate size.

    Ideally - shrinking should be done by doing all the steps in your list.

    Which never happens (apart of the databases I'm in charge of :-P).

    _____________
    Code for TallyGenerator