Advertisements
HEADLINES

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
SET RECOVERY SIMPLE;
GO
— Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks2012_Log, 1);
GO
— Reset the database recovery model.
ALTER DATABASE AdventureWorks2012
SET RECOVERY FULL;
GO

For more information, please refer MSDN site

“Yours, Ravi Theja Madisetty”

Advertisements

1 Trackback / Pingback

  1. Logon error Dynamics AX Client | TECHNOGUNS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s