How to Shrink Log File - Dynamics NAV SQL Database

Hi All,
Following example will show how to shrink the log file when the database reached maximum size, there is an alternate way is available to resolve this problem.

if your SQL database for Dynamics NAV reached maximum size then you have two options

Option 1

1. Expand the database size (File -> Database -> Expand)
2.Enter new size in Expand Database screen

Option 2
run below query to shrink log file 

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

Replace NAVDemo by your database Name



Thanks
Jerome Marshal .J