upgrade crm 4.0 to crm 2011 handle attachment upgrade and upgrade indexes


  • We have a crm 4.0 database of over 800GB and out of which attachments are occupying around 620GB. While upgrading to crm 2011 below are the issues i am facing any suggestions on how to reduce the time.

    1. Step: Handle attachment upgrade after pass 1 is taking 8 hrs.

    2. Step: upgrade indexes is taking more than 1 day and still continuing. 

    I had followed all the recommended options from Microsoft described in below links and had set OptimizeOrgImport to 1 and had rebuild indexes and updated the stats.


    Any other suggestions

    Wednesday, August 21, 2013 9:54 PM

All replies

  • I don't think is much more that you can do to shorten the upgrade time. An 800GB database is very large. Is there anything you can do to reduce the size of the database before the upgrade. Have you removed entries for asynchronous jobs etc.? This article has some info http://support.microsoft.com/kb/968520/en-us

    Also, check the size of the CRM database tables in SQL Server Management Studio to see which tables have the most data (apologies if you've already done this) to help you focus attention on particular entities.

    Wednesday, August 28, 2013 8:53 AM
  • HI Satya,

    Can you please share me the size of the Database file *_MSCRM.MDF & *_ MSCRM.LDF. 

    If your .LDF file size is in GB then you need to shrink the data base to reduce the size. 

    you can find this in following path.

    Before doing the  changes take the backup of data base. 

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\

    After restoring can you run these following query's.



    Pavan Joshi 



    Wednesday, August 28, 2013 10:08 AM