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

pic1

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.

pic2

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

pic3

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 .

Advertisements

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,
    mscrmsupport.wordpress.com – da best. Keep it going!
    Thank you
    Jinny

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s





%d bloggers like this: