mscrm_log and sql timeout error in Microsoft CRM 4.0

Is your MSCRM_log file getting bigger and bigger? Have you ever considered looking at MSCRM_log.LDF?

The first thing you witness is sqltimeout error and it is almost impossible to use CRM application. If you look at SQL logs, there will be somethingĀ  like


In order to overcome , one need to shrink the log database file. Remember to take the back-up of CRM database and then go through from these two figures.


Right click CRM Database …Task…Shrink and then choose ….Files. Now one need to choose mscrm_log.


This process will release unused pages. If logfile does not get smaller then you need to check the properties of Database if Option of “Full Recovery” is selected ? Change it to “Simple” and then shrink it. Remember to change it back to Full recovery once you are done .


2 Responses to “mscrm_log and sql timeout error in Microsoft CRM 4.0”

  1. 1 Jinny May 2, 2009 at 12:38 am

    Hi, – da best. Keep it going!
    Thank you

  2. 2 How I Shed T h i r t y P o u n d s in Thirty Days May 6, 2009 at 3:14 am

    Hi, interesting post. I have been thinking about this issue,so thanks for writing. I’ll certainly be subscribing to your site. Keep up the good work

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: