Tag Archives: DynamicsAX database

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 AX database. USE AdventureWorks2012; GO — Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AdventureWorks2012 …

Read More »