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

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

    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