• I know that we use it in our environment for a HA scenario, but cannot speak for an industry as a whole. If you are looking at upgrading soon you may want to look at Always-On as it is replacing Database Mirroring as the preferred HA option.

    Checkpoints happen both automatically by the SQLOS, automatically for certain operations and can happen manually.

    CHECKPOINT (Transact-SQL)

    Joie Andrew
    "Since 1982"