database used kb near to reach from 100% are this will make proplem

Business Central/NAV Technical Forum
1

Hi guys i have sql server 2005 connect with dynamic nav 2009 r2 i open file-database - information

i found following :

database used kb 269440

database size kb 304896

object cache kb 32000

percentage used 88%

Are there are any proplem if database used reach untill 100%

my license is client license

and i dont using demo or acronus

2

It depends on how the database is setup. Entire it is set to auto-grow - in which case there will not be a problem (as long as you have space enough on your disk). Otherwise you need to expand the database. When it runs full it will stop working.

You can check the current setting and expand the database from File->Database->Alter.

3

Hi Ahmend,

You can alter database as erik said you have one more option since you are using SQL database you can shrink the log file also.below query can be used to shrink log file here NAVDemo is database name

USE NAVDemo
GO
DBCC SHRINKFILE(NAVDemo_Log, 1)
BACKUP LOG NAVDemo WITH TRUNCATE_ONLY
DBCC SHRINKFILE(NAVDemo_Log, 1)
GO

Thanks

Jerome Marshal. J

4

Thank you guys for reply

in my case are this will make problem if reach to 100%

i don’t need to expand if i leave it it will make problem if it reach to 100%this is actual y my question

and if it make problem what i do

5

If you are getting a problem when it hits 100% and it doesn’t expand automatically, then you will just have login in and manually expand the database.

But check the setup in the Alter database (file tab), as described above. Then you’ll know for sure if it will expand automatically.

If you created the database using NAV, then the default setting is that it will expand automatically.

6

How does this solve the problem?