Shrink Database in Microsoft Dynamics 365 [F&O]

There are 2 ways to trigger the shrink.

First approach is from the below path.

Select the file type ‘ Log’ option and click Ok.

This takes sometime to complete and when it finishes the SQL log drive would have more free space.

Approach 2 is to execute a query from SQL which does the job instantly.

ALTER DATABASE AxDB SET RECOVERY SIMPLE;

USE AxDB;
GO
CHECKPOINT;
GO
CHECKPOINT;
GO
DBCC SHRINKFILE(AxDBCopy_log, 1000); -- 1000 = 1GB
GO