Sage 100

 View Only

Premium Database Maintenance

  • 1.  Premium Database Maintenance

    Posted 01-02-2020 10:26
    Good Morning, and welcome back to reality!
    Customer recently moved to Premium v2019 from Advanced and IT sent me this email:

    Do you have a list of best practices for the Sag100C database.  Is it recommended to do a weekly Reorganize Index or rebuilding index on the databases?  Any other recommended regular SQL maintenance tasks beyond backups?

    I have no idea, does Sage recommend anything or do the Premium Guru's here have any best practices they recommend?
    Does it hurt/help to do these tasks he is asking about on a regular basis?

    Thanks
    Nancy



    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------