Database Status inquiry NAV2009

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report
Copy link

Link copied!

Hi Magil,

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

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Rabin 2,976 on at

Like (0)

Report
Copy link

Link copied!

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...

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

Was this reply helpful? Yes No