Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Database Status inquiry NAV2009

(0) ShareShare
ReportReport
Posted on by

Hi Sir,

May I ask regarding NAV database status in our company? The current status is 98%. What will happen if the status reach in 100%? Will the NAV users create more transactions? Need your advice regarding on this.  Please see print screen for you to view the database status.

*This post is locked for comments

  • Suggested answer
    Rabin Profile Picture
    2,976 on at
    RE: Database Status inquiry NAV2009

    Hi Magil,

    I agree with other experts,

    For NATIVE(CLASSIC) DB you can do it manually..

    For SQL You do not need to worry, just increase the size of DB from its property...

    -------------

  • Suggested answer
    Ashwini Tripathi Profile Picture
    4,624 on at
    RE: Database Status inquiry NAV2009

    As alreaady suggested by other members, In SQL it is defaultly setup to grow by 10% which you can change from SQl Server Database Property window. In case of Native you need to Ater the size of database by adding no of bytes.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Database Status inquiry NAV2009

    As Khoa Nguyen mentioned, the answer depends on whether your database is a native or SQL.

    If you have native database, you can expand the database size by the needed size (tutorial.programming4.us/.../microsoft-dynamics-nav---expanding-the-database.aspx).

    If you have SQL database, it depends on the settings you have. If the Unrestricted Growth option is not selected and the database has grown to its maximum size, then you can either select the Unrestricted Growth option or increase the maximum size of one of the secondary data files.

  • Suggested answer
    4BzSoftware Profile Picture
    6,073 on at
    RE: Database Status inquiry NAV2009

    Hi Magil,

    Is it SQL database or NAV Native database? For SQL database, it is auto grow 10% by default.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans