While Importing CRM, system is generating huge Log 200+ GB(My Org DB size is 250+GB space) RRS feed

  • Question

  • Current system info

    DB size : 250 GB

    Table size : 20 GB ( 2 Entity)

    User : 400+

    Problem : space crunch

    Tuesday, February 15, 2011 6:06 AM

All replies

  • What recovery option do you have on SQL Server? Most DBAs are happy with 'Simple'.

    Neil Benson, CRM Addict and MVP at Customery Ltd. You can reach me on LinkedIn or Twitter. Join over 10,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Tuesday, February 15, 2011 8:46 AM
  • As Neil suggests the SQL Database recovery options affect what happens to the transaction log size; however I'd suggest you take your backup/recovery strategy into account before changing this.

    Another consideration is that the import process by default modifies a lot of records. Update Rollup 8 introduced an optimised process which I expect would significantly reduce the number of records that are updated, and hence the impact on the transaction log. This needs to be enabled via the registry, as described in http://support.microsoft.com/kb/977867

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, February 15, 2011 3:02 PM