Showing posts with label log file. Show all posts
Showing posts with label log file. Show all posts

Wednesday, October 18, 2023

Shrink log D365FO log file

 Shrink log D365FO log file 

Select DB -> Right click -> Tasks -> Shrink -> Files

select file type as "Log".

Note down the value of file name.




Right click the Database -> New query -> Execute below query.

       ALTER DATABASE AXDB

        SET RECOVERY SIMPLE

        GO

      -- DBCC SHRINKFILE (filename , 1)

        DBCC SHRINKFILE ('AXDB-17Mar_log', 1)

        GO

        ALTER DATABASE AXDB

        SET RECOVERY FULL


** replace your file name