Shrinking NAV Database

jhanvincent14
jhanvincent14 Member Posts: 214
in NAV Three Tier
Is shrinking NAV Database advisable? if not, why ? what if I only shrink the Log File and not the entire database?

Thanks and Advance.

Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    edited 2019-04-03
    If you shrink your log file it will grow back. The only point where you should shrink the log file is after restoring the native backup in NAV, or reindex large amount of tables all in in one step. The native NAV backup restore operation blows up transaction log artificially, as all the restore is one big operation.

    Apart from that shrinking log will not help you with anything.

    Shrinking database is not advisable as it fragments heavily internal table structures. If you really need need to shrink your database files (for example because you need to recover some free space) you should follow it by rebuilding indexes on all tables, and then eventually by shrinking the transaction log - but not to a minimum size you can, but to the size it was prior re-indexing.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories