Microsoft Dynamics NAV 2018 SQL Server Database Size

(0) Share

Report

Posted on by Sal Urbina

I'm looking for some guidance on our MS Dynamics Nav 2018 database growing out of control and what we could adjust to help reduce size.

Our DB size is 179282 MB comprised of

our .mdf PRIMARY file size 399961.6 MB, of this 1782.437500 MB is Free Space

our .ldf log file size 38254.016 MB, of this 36821.468750 MB is Free Space

our .ndf Data Filegroup_1 file size 105369.6 MB, of this 335.500 MB is Free Space

we are on WS2012R2

we are on Microsoft SQL Server Management Studio 13.0.15900.1
Microsoft Analysis Services Client Tools 13.0.1700.281
Microsoft Data Access Components (MDAC) 6.3.9600.20665
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.20671
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600

We are on Version US Dynamics NAV 11.0

11.0.22292.0

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

RE: Microsoft Dynamics NAV 2018 SQL Server Database Size

Hi, you can try date compression feature in NAV.

https://forum.mibuso.com/discussion/15885/steps-on-doing-date-compression

Hope this helps.

Thanks.

ZHU