CCM3 - SQL Database Log File needs shrunk

[rwamstutz]

All,

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?

[gogasca]

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:

http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_tech_note09186a008049aab0.shtml

[rwamstutz]

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?