CRM Database Log Files Getting Very Large

Does anyone know why the database log file for the MSCRM 
database would be growing exponentially large? 

I setup MS CRM in a test environment, and haven't even 
added any data to the database yet. But in the few weeks 
that the server has been running, the MSCRM log file has 
grown to over 6G. A full database backup is done every 
night using Veritas. I've tried backing up and truncating 
the log files also, but it didn't reduce the size of the 
log files either. The log file shrinking option in SQL 
Enterprise Manager indicates that the file can be shrunk, 
but only be a small amount. Considering that there isn't 
any data in the database, I assume this log file is full 
of garbage. Is it OK to delete it?

If this is considered normal performance, it is hard to 
imaging this product functioning in a production 
environment.
0
shepburn (1)
10/13/2003 3:55:10 PM
crm 35858 articles. 1 followers. Follow

4 Replies
789 Views

Similar Articles

[PageSpeed] 35

Simon,

This is a common problem with CRM.  There seems to be a lot of "admin"
functions that run periodically that cause the logs to grow.  One thing you
might try is to add log backups to your schedule.  Even though you do a full
backup, the actual log does not get backed up.  As a result, SQL keeps
adding to the file and won't reuse the space in the file.

As you indicate this is a test environment, another option is to change the
recovery mode to Simple instead of Full.  In this mode, the information in
the log is truncated after each transaction commits.  As a result, it won't
keep growing on you.

As for reducing the log size, you can do this manually via the shrink
databases option in Enterprise Manager.  If EM is indicating that is can't
be shrunk, then truncate the log first, then try again.  Depending on the
options on the file allocation, you may have to shrink the log several times
since there is overhead involved in the extent allocation that gets removed
each time you shrink.

Matt
"Simon" <shepburn@tekagency.com> wrote in message
news:01c401c391a2$618d1030$a301280a@phx.gbl...
Does anyone know why the database log file for the MSCRM
database would be growing exponentially large?

I setup MS CRM in a test environment, and haven't even
added any data to the database yet. But in the few weeks
that the server has been running, the MSCRM log file has
grown to over 6G. A full database backup is done every
night using Veritas. I've tried backing up and truncating
the log files also, but it didn't reduce the size of the
log files either. The log file shrinking option in SQL
Enterprise Manager indicates that the file can be shrunk,
but only be a small amount. Considering that there isn't
any data in the database, I assume this log file is full
of garbage. Is it OK to delete it?

If this is considered normal performance, it is hard to
imaging this product functioning in a production
environment.


0
Matt
10/13/2003 4:25:15 PM
One more thing, for more info on how SQL manages space allocation with Logs
and what factors into what it can and cannot "shrink", look up the following
topic in the SQL Books Online:  "shrinking transaction logs"

Matt

"Matt Parks" <Matt.Parks@removetoX_XRevereGroup.Com> wrote in message
news:%23lp5eaakDHA.1764@tk2msftngp13.phx.gbl...
Simon,

This is a common problem with CRM.  There seems to be a lot of "admin"
functions that run periodically that cause the logs to grow.  One thing you
might try is to add log backups to your schedule.  Even though you do a full
backup, the actual log does not get backed up.  As a result, SQL keeps
adding to the file and won't reuse the space in the file.

As you indicate this is a test environment, another option is to change the
recovery mode to Simple instead of Full.  In this mode, the information in
the log is truncated after each transaction commits.  As a result, it won't
keep growing on you.

As for reducing the log size, you can do this manually via the shrink
databases option in Enterprise Manager.  If EM is indicating that is can't
be shrunk, then truncate the log first, then try again.  Depending on the
options on the file allocation, you may have to shrink the log several times
since there is overhead involved in the extent allocation that gets removed
each time you shrink.

Matt
"Simon" <shepburn@tekagency.com> wrote in message
news:01c401c391a2$618d1030$a301280a@phx.gbl...
Does anyone know why the database log file for the MSCRM
database would be growing exponentially large?

I setup MS CRM in a test environment, and haven't even
added any data to the database yet. But in the few weeks
that the server has been running, the MSCRM log file has
grown to over 6G. A full database backup is done every
night using Veritas. I've tried backing up and truncating
the log files also, but it didn't reduce the size of the
log files either. The log file shrinking option in SQL
Enterprise Manager indicates that the file can be shrunk,
but only be a small amount. Considering that there isn't
any data in the database, I assume this log file is full
of garbage. Is it OK to delete it?

If this is considered normal performance, it is hard to
imaging this product functioning in a production
environment.



0
Matt
10/13/2003 4:36:56 PM
Thanks! I suspected as much - CRM seems to just keep 
filling the log file up with garbage and using all the 
disk space on the server.

The MSCRM log file has now reached 9G in size. Changing 
the recovery type to Simple seems to slow the growth, but 
doesn't stop it. I changed the recovery method back to 
Full, ran a log file backup to truncate the logs, then 
shrank the log file. SQL Enterprise Manager says the log 
file has been successfully shrunk (to 138 MB), but it 
doesn't physically reduce the file size, even after 
multiple tries.







>-----Original Message-----
>One more thing, for more info on how SQL manages space 
allocation with Logs
>and what factors into what it can and cannot "shrink", 
look up the following
>topic in the SQL Books Online:  "shrinking transaction 
logs"
>
>Matt
>
>"Matt Parks" <Matt.Parks@removetoX_XRevereGroup.Com> 
wrote in message
>news:%23lp5eaakDHA.1764@tk2msftngp13.phx.gbl...
>Simon,
>
>This is a common problem with CRM.  There seems to be a 
lot of "admin"
>functions that run periodically that cause the logs to 
grow.  One thing you
>might try is to add log backups to your schedule.  Even 
though you do a full
>backup, the actual log does not get backed up.  As a 
result, SQL keeps
>adding to the file and won't reuse the space in the file.
>
>As you indicate this is a test environment, another 
option is to change the
>recovery mode to Simple instead of Full.  In this mode, 
the information in
>the log is truncated after each transaction commits.  As 
a result, it won't
>keep growing on you.
>
>As for reducing the log size, you can do this manually 
via the shrink
>databases option in Enterprise Manager.  If EM is 
indicating that is can't
>be shrunk, then truncate the log first, then try again.  
Depending on the
>options on the file allocation, you may have to shrink 
the log several times
>since there is overhead involved in the extent allocation 
that gets removed
>each time you shrink.
>
>Matt
>"Simon" <shepburn@tekagency.com> wrote in message
>news:01c401c391a2$618d1030$a301280a@phx.gbl...
>Does anyone know why the database log file for the MSCRM
>database would be growing exponentially large?
>
>I setup MS CRM in a test environment, and haven't even
>added any data to the database yet. But in the few weeks
>that the server has been running, the MSCRM log file has
>grown to over 6G. A full database backup is done every
>night using Veritas. I've tried backing up and truncating
>the log files also, but it didn't reduce the size of the
>log files either. The log file shrinking option in SQL
>Enterprise Manager indicates that the file can be shrunk,
>but only be a small amount. Considering that there isn't
>any data in the database, I assume this log file is full
>of garbage. Is it OK to delete it?
>
>If this is considered normal performance, it is hard to
>imaging this product functioning in a production
>environment.
>
>
>
>.
>
0
Simon
10/22/2003 9:04:41 PM
Simon,

When recovery is set to Simple, there shouldn't be any consistent, steady
growth to your log file.  If there is, then you have another problem like a
runaway process.  In Simple mode, the data that is written to the log during
a transaction is immediately relased when the transaction commits.  So, you
might see some growth to the file to accomodate a large transaction, but it
should stay fairly static.

On our demo environment (which at one point had a 1GB log), I shrunk our log
down a few months ago and it is still at 500KB in size running with Simple
recovery.

BTW, when you are in Full Recovery, you need to cycle through the steps of
Backup Log, Shrink DB, Backup Log, Shrink DB to get to the smallest possible
log size.

Matt

"Simon" <anonymous@discussions.microsoft.com> wrote in message
news:0bcc01c398e0$1c9ea0c0$a001280a@phx.gbl...
Thanks! I suspected as much - CRM seems to just keep
filling the log file up with garbage and using all the
disk space on the server.

The MSCRM log file has now reached 9G in size. Changing
the recovery type to Simple seems to slow the growth, but
doesn't stop it. I changed the recovery method back to
Full, ran a log file backup to truncate the logs, then
shrank the log file. SQL Enterprise Manager says the log
file has been successfully shrunk (to 138 MB), but it
doesn't physically reduce the file size, even after
multiple tries.







>-----Original Message-----
>One more thing, for more info on how SQL manages space
allocation with Logs
>and what factors into what it can and cannot "shrink",
look up the following
>topic in the SQL Books Online:  "shrinking transaction
logs"
>
>Matt
>
>"Matt Parks" <Matt.Parks@removetoX_XRevereGroup.Com>
wrote in message
>news:%23lp5eaakDHA.1764@tk2msftngp13.phx.gbl...
>Simon,
>
>This is a common problem with CRM.  There seems to be a
lot of "admin"
>functions that run periodically that cause the logs to
grow.  One thing you
>might try is to add log backups to your schedule.  Even
though you do a full
>backup, the actual log does not get backed up.  As a
result, SQL keeps
>adding to the file and won't reuse the space in the file.
>
>As you indicate this is a test environment, another
option is to change the
>recovery mode to Simple instead of Full.  In this mode,
the information in
>the log is truncated after each transaction commits.  As
a result, it won't
>keep growing on you.
>
>As for reducing the log size, you can do this manually
via the shrink
>databases option in Enterprise Manager.  If EM is
indicating that is can't
>be shrunk, then truncate the log first, then try again.
Depending on the
>options on the file allocation, you may have to shrink
the log several times
>since there is overhead involved in the extent allocation
that gets removed
>each time you shrink.
>
>Matt
>"Simon" <shepburn@tekagency.com> wrote in message
>news:01c401c391a2$618d1030$a301280a@phx.gbl...
>Does anyone know why the database log file for the MSCRM
>database would be growing exponentially large?
>
>I setup MS CRM in a test environment, and haven't even
>added any data to the database yet. But in the few weeks
>that the server has been running, the MSCRM log file has
>grown to over 6G. A full database backup is done every
>night using Veritas. I've tried backing up and truncating
>the log files also, but it didn't reduce the size of the
>log files either. The log file shrinking option in SQL
>Enterprise Manager indicates that the file can be shrunk,
>but only be a small amount. Considering that there isn't
>any data in the database, I assume this log file is full
>of garbage. Is it OK to delete it?
>
>If this is considered normal performance, it is hard to
>imaging this product functioning in a production
>environment.
>
>
>
>.
>


0
Matt
10/22/2003 10:15:56 PM
Reply:

Similar Artilces:

Launching Excel by clicking Excel file
I recently lost the ability to launch WinXP 2003 Excel successfully by clicking on a file. Actually, Excel opens but no file appears - grey screen. When I click an Excel file, Excel launches but does not load the file - I have to then open the file via Excel's open commands (File=>Open). I can't seem to trace the problem back to any event. Thanks for any insight. CW I'd be doing some Excel troubleshooting. http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "CDWhite" <none...

ALL of my email is gone- getting error message as well
I am getting this message: The message store has been corrupted by an application external to Windows Mail. Windows Mail has been able to successfully recover from this corruption. (0x0000000) In addition ALL of my emails are gone. Any suggestions on how I can recover them? And what I should do about the message. Try running the various repair functions in the WMUtil program: http://www.oehelp.com/WMUtil If still no improvement, upgrade to Windows Live Mail: http://download.live.com/wlmail It will automatically import all your WM data. Gary VanderMolen, Microsoft MVP (Mai...

How do I track emails ONLY using tokens in CRM 4.0?
The pattern matching or "intelligent" matching of email content is misapplying inbound emails to non-related cases. I want to turn this feature OFF ASAP and return to ONLY tracking through tokens in the subject line. I can turn OFF tokens but not the smart matching. A configuration option would have been nice. I think you turn on the tokens, and then your users have to use the option to only track "E-mail messages in response to CRM e-mail" - that's how you prevent CRM from using 'smart' matching. Dave Ireland "Forrest_Adam" <ForrestAd...

Query File As
My Table Fields First Middle Last Suffix Need the new field in the qurey Will be FileAs: What is the expression so that FileAs displays Last (space) Suffix (if not null) then a (,) and a (space) then Fist (space) Middle Can anyone give me the correct expression for this so I can copy and paste from your reply Thank You from Marsman Try this -- IIF([Last] Is Not Null, [Last] & IIF([Suffix] Is Not Null, " " & [Suffix], "") & ", " & [First], & " " & [Middle], "") -- Build a little, test a little...

To Open Pocket PC Excel file using Excel 2000
I have copied an Excel file created using Pocket PC Excel program in my PDA (.pxl) to my notebook. BUT i cannot open the file using my Excel 2000 s/w in my notebook. Please help. ...

CRM Field Names
Is there a list on field names that CRM creates in the database in order to use them for setting up workflow? ...

CRM 3.0 and CRM 4.0
Dear All, We were implementing MSCRM for a very protential CRM customer (Education). Even they haven't signed the contract but we already started developing on the CRM 3.0, 3 weeks ago. A lot of customisation + .NET developing required on the version 3 but now we knew that we're reinventing the wheels as some of them will be already built in the V4 which one will be realease very soon (Q1-2008?) If we place order to MS now, we will receive the V4 earlier than Q1-2008, but it is V4, not V3 So now we decided moving the developing on V4 directly because no guarantee what we wer...

Client Action Logging
Is there any convenient way to log client actions when they connect via RPC? I've searched every log I can find and every logging option I can find (POP3, IMAP4, etc.). No attempt to reveal this information has succeeded. I've found no obvious option that does this We are using Exchange 5.5 and Oulook clients. We have been receiving reports that messages are being sent from our users but not getting delivered until the next day. I've looked at the smpt logs and, in some circumstances, DNS and various other errors do occur. Those are easily verified. What I cannot do ...

Organizational Settings in CRM 3.0
Is it possible to hide viewing of Organizational Settings from non System Administrator users? ...

CRM and MapPoint
I have a client that has MapPoint 2004. They would like to have the ability to map all of their current clients in certain areas, also with the ability to make indication of future growth in these same areas. Currently, they can only map one facility at a time. They would like to be able to map all of their existing and future facilities for a spcific service area on one map. Does anyone know of a solution for accomplishing this? Thanks, -Rick Not a mappoint expert by any means but I think there are 2 choices: 1. Export data from CRM (can probably just use the excel export option)...

Recently used File List
Can someone tell me why, after downloading a template from the Microsoft website my recently used file list dumps the files I have just used from the list when I close Excel. All I ever have now are the downloaded Excel templates listed and cannot get rid of them. Thank you Rob ...

Database problem when in Vista
I have a database that works fine when I am Access 2003 in Windows XP. When I transfer the database to another computer running Access 2003 in Vista I am not able to run any of my reports. I am sure the problem is when I open the database I am asked about wanting to block unsafe coding. Can anyone help so that I can fully run my database in Vista. Thanks. JoeP Create a short with the Run As Administrator box checked, and use that to start Access. Details in Option 2 here: http://allenbrowne.com/bug-17.html Once you get Access open, go to the Tools menu, Macros, and set Security to...

Cannot access CRM homepage on another machine
Hi, I have installed CRM 1.2 on a Windows Server 2003 SP1 machine. I can work with CRM on this machine using http://localhost. But when I try to access the homepage on another computer by typing http://CRMserver or http://IP address of CRM server I cannot access it. Can anyone please tell what do I have to configure to access the homepage on another machine? Thanks and Regards, Harshad ...

Reset CRM
Hi, How can I reset CRM database? I create contacts, acounts, invoices, etc., and i want delete all. Tnhank's, RS You cannot reset the database. You could restore the database if you took a backup before you started adding data. You can also go into the system and start deleting records. Can I ask why you need to do this? Have you been experimenting with CRM and now want to go to a live server? -- John O'Donnell Microsoft CRM MVP http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx "Ricardo" <anonymous@discussions.microsoft.com> wrote in mes...

lost files...
Was cleaning up my Outlook...checking files, etc. Since this Outlook is for business, it is loaded with e-mails, forms, etc. To my horror....and I don't believe I did anything...all my files and e-mail from yesterday on...poofed...magic...all gone. Now I know I didn't delete...but I have no clue where they are at this moment. Have been doing a search of my files, thinking they might be playing hide and seek on me. Please...Please...tell me what happened..and how I'm able to rescue this work. Thank you.. Usually cleaning up means deleting. If you've checked all t...

Vista CRM 3.0 Desktop client
Can someone tell me where I can find the CRM 3.0 Desktop client which works with Vista & Office 2007? Thanks You can download it using the following link. http://www.microsoft.com/downloads/details.aspx?FamilyID=740e1b3b-11c3-4aef-b2e3-8309e0cf1bb0&DisplayLang=en Magui "circulent" <circulent@discussions.microsoft.com> wrote in message news:27D9D594-593F-4C1D-9E61-09F946FFA8BB@microsoft.com... > Can someone tell me where I can find the CRM 3.0 Desktop client which > works > with Vista & Office 2007? > > Thanks ...

3-rd tools to Recovery edb files
Do you know any good tools to restore single mail or single mailbox from offline backup Exchange database files (edb or stm files). thanks http://www.officerecovery.com/exchangeserver/ -- My Regards, Omar El-Sherif "Luk" <only4news@gmail.com> wrote in message news:eox4HmrPGHA.2828@TK2MSFTNGP12.phx.gbl... > Do you know any good tools to restore single mail or single mailbox from > offline backup Exchange database files (edb or stm files). > > thanks try http://www.ontrack.co.uk/powercontrols/ - they've been around for a few years now and seem to have a...

How works conflictresolution with the offline outlookclient and ms crm?
Hi Does somebody know how the conflictresolution works if one ore more offlineclients synchronise to the server. How does it work if diffrent offlineclientds did some changes on the same field? Does someone know a good description about this problem? Thank's Michel Consider a situation where a field has been changed. 1. Two offline clients making a change 2. One offline and the second online client making a change when the client goes online the data present in the client is synchronised and saved irrespective of the time when the last changes were made to the field. "Hope...

CRM registration can not be done!
After CRM installation and valid internet connection via LAN, I could not succeed to register CRM 3.0. Is there anybody who had this problem before and solve it?? When you fill in the registration details, if you specify the implementation was done by a partner company, make sure you fill in data in all fields for the partner company, otherwise the registration process can fail -- David Jennaway - Microsoft Dynamics CRM MVP Web: http://www.excitation.co.uk "Pleiades" wrote: > After CRM installation and valid internet connection via LAN, I could > not succeed to registe...

? on creating PDF files
To print reports as a PDF file, are the only requirements that a PDF writer is installed on the local machine? Will GP automatically detect this and give you the option to print a PDF file once it is installed? I can't seem to get this to work with Adobe Acrobat 6.0. Thanks DJ, It will work as long as the Adobe PDF printer is the default printer, otherwise, you will have to manually change the Printer Setup in GP BEFORE printing any report to PDF. Once changed, all reports will go to Acrobat PDF by default while you are logged into GP. Best regards, -- MG.- Mariano Gomez, MI...

Transaction Log Files #3
How do I calculate total Transaction Log file size on Exch2k3SP1 when I move mailboxes with, for example, total size of 100MB from one server to another (1 Storage Group, one Mailbox store)? -- Kind regards, Menko den Ouden NL On Wed, 5 Oct 2005 10:21:04 +0200, "Menko den Ouden" <oudenmd@exor-itNOSPAM.nl> wrote: >How do I calculate total Transaction Log file size on Exch2k3SP1 when I move >mailboxes with, for example, total size of 100MB from one server to another >(1 Storage Group, one Mailbox store)? I always assume "alot". If you are worried...

Get blank IE window when I go to link
Been using Outlook Express 5.0. No problems to recently. When I go to hit a link in an e-mail it just comes up a blank IE screen. Does not even say done. Tried dowloading and installing 6.0 but no difference. I use an ISP, Windowns '98 SE, Pentium3, 128mb ram 10gb hard drive. Have scaned disk and defraged. Spent 8 hours and still no luck. So I am here. Dell ...

File in Use Error
Hello, I have a excel spreadsheet with two worksheets, each of which connects to the same Access database via an ODBC connection to retrieve data. The worksheets have different data and are pulling from different tables in access. I was able to do this without any problem but since I am the owner and creator for both files I did not forsee any problems. Now I need another individual to do this task but when they open the excel file they get 'File in Use :|' error. The person has read, write, modify and excute rights to the database. Any help will be appreciated. Thank you. Sini ...

More than 9 recent files used
Does someone know how to increase the 'recently used files' to more tha 9? If that can't be done, is there another way to get the same thing? I would be nice to have a sub-menu in the File/Open menu that pops ou and lists the files. :confused ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ...

Migrating CRM to CRM
We had to delete the OU from the Active Directy, and now cannot get to our data. Reading through the posts it looks as though we have to use the DMF to convert our data because of the GUIDs that are hard-coded in the files. Unless someone knows of a utility that I can use to change the GUIDs in the Active Directory - but we tried a number of different things. So, is there an easy method to import CRM data into CRM? I tried using SQL DTS to the cdf_entities, but this is like pulling teeth, and don't know if I am going to be losing any data. Anyone have any insight into getti...