CCM3 - SQL Database Log File needs shrunk

Unanswered Question
Aug 3rd, 2007
User Badges:


I have a CCM3 db log file that is 940m and I have an error on my CCM saying that the log file is too full. The actual database file is 17mb. How do I shrink the log file to get the db back up and running?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
gogasca Fri, 08/03/2007 - 18:51
User Badges:
  • Green, 3000 points or more

From SQL Query analyzer select the CCM030X DB from the pull-down and execute the following query:

dump tran "CCM030X with no_log

dbcc shrinkdatabase (CCM030X

This will shrink and truncate the transaction logs.

Just FYI, this one is for CDR|ART:

rwamstutz Mon, 08/06/2007 - 04:29
User Badges:

Will this do just the log file? can you clarify, if my database is CCM0300 and the log file is CCM0300_log, how would the command read?


This Discussion