Import AXModelStore Log files

When you import an AXModelStore into AX2012 you will encounter the model database log file growing to many gigabytes. Microsoft’s recommendation is to make the log file for the model store database at least 60GB.

If you are not creating a tempoary scheme and just doing a full release, then there are a couple of tricks you can use to reduce this explosion of log file size.

Trick 1: Switch the recovery model from full to simple. Typically I never user full for the model database, as I have backs and AXmodelstore files so can easily rebuild, and since development should not happen on a test or production environment there should be no changes to the database, so no need for a full recovery model.

Trick 2: Pre delete the records from the model database. Using the following SQL script you can pre delete the records that the AXModelStore import routine will delete as part of the import:

DELETE FROM [dbo].[SYSXPPASSEMBLY];
DELETE FROM [dbo].[ModelSecurityCommon];
DELETE FROM [dbo].[ModelSecurityRole];
DELETE FROM [dbo].[ModelSecuritySubRole];
DELETE FROM [dbo].[ModelSecurityPermission];
DELETE FROM [dbo].[MODELSECPOLRUNTIMEEX];
DELETE FROM [dbo].[ModelSecurityPolicyTable];
DELETE FROM [dbo].[ModelSecurityPolicyConstraint];
DELETE FROM [dbo].[ModelSecurityPolicy];
DELETE FROM [dbo].[GlobalFieldIdPool];
DELETE FROM [dbo].[LayerVersioning];
DELETE FROM [dbo].[Sources];
DELETE FROM [dbo].[ModelManifest];
DELETE FROM [dbo].[ModelOperationHistory];
DELETE FROM [dbo].[ModelManifestCategory];
DELETE FROM [dbo].[ModelElementLabel];
DELETE FROM [dbo].[ModelElementData];
DELETE FROM [dbo].[ModelElement];
DELETE FROM [dbo].[ElementTypes];
DELETE FROM [dbo].[Model];
DELETE FROM [dbo].[Layer];
DELETE FROM [dbo].[ModelGroup];

The results: Typically I find the standard model database requires a log file of 30GB with the recovery model set to simple (Trick 1).  If I pre delete the records from the model database (Trick 2) then this will further reduce the log file maximum size to 10GB.