Tag Archives: Shrinklog

Shrink SQL Database log file to One MB

Every AX administrator should know how to shrink AX database logs from the SQL management studio. You can run below SQL command with respect to your AX database. ** Replace ‘AdventureWorks2012‘ with your database name < p style=”text-align: left;”>USE AdventureWorks2012; GO /Truncate the log by changing the database recovery model to SIMPLE/ ALTER …

Read More »