Recently, we had a MS Dynamics CRM 4.0 database that had a bad Duplicate Detection job in it. The job had been running for months and the database had grown gig’s in size before we found it. There were 16 million records in the Duplicate Detection table – ouch. We followed another article to find the offending rule, disable the rule and then clear out the database.
This left a 17gig SQL log file and was basically wasting lots of space on disk and backups. Hunted round the web and got all sorts of conflicting stories on how to shrink the log file down to a reasonable size. Long story short, we used this script below – shrunk the 17gig log file down to 1mb…..
To read the full article follow this link: http://www.mhaltd.co.nz/Blog/tabid/106/EntryId/5/Shrinking-a-Dynamics-CRM-4-0-Database-Log-File.aspx
If you are interested in Hosted Microsoft Dynamics CRM 4.0 follow this link: http://www.mhaltd.co.nz/Products/HostedServices/ManagedCRM.aspx
