Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Recommended Database Maintenance

Posted on by 60

Hello, 

What is the recommended database maintenance procedures for GP2018 R2. I've noticed that the DBMaintenance.exe is missing and we are running into issues with SSRS. Would creating a scheduled index rebuild cause any issues?

Thank you

  • Verified answer
    RE: Recommended Database Maintenance

    The Database Maintenance Utility actually is only used to re-create objects such as indexes, stored procedures, triggers, functions, it really doesn't do database maintenance, if that is what you're truly looking for.

    (FYI, you can copy a DBMaintenance.exe from a GP 2018 install, and copy/paste it into a GP 2018 R2 directory and it will work fine. You can't copy it from a prior version of GP, such as GP 2016, as the application version won't match the GP version, thus will throw a version error)

    I'd recommend the following:

    CustomerSource:

    Recommended Maintenance with Microsoft SQL Server for Microsoft Dynamics GP Databases:

    mbs.microsoft.com/.../MSD_GPRecommendedMaintenanceSQLDatabases

    PartnerSource:

    Recommended Maintenance with Microsoft SQL Server for Microsoft Dynamics GP Databases:

    mbs.microsoft.com/.../MSD_GPRecommendedMaintenanceSQLDatabases

    mbs.microsoft.com/.../MDGP2010_WhitePaper_Performance

    These links have information on a database maintenance plan to use with Dynamics GP, as well as performance information on maintaining and optimizing a Dynamics GP environment.

    Thank you,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans