Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Current system info

    DB size : 250 GB

    Table size : 20 GB ( 2 Entity)

    User : 400+

    Problem : space crunch

    Shubh
    Tuesday, February 15, 2011 6:06 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator