Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
259
Views
0
Helpful
2
Replies

CCM3 - SQL Database Log File needs shrunk

rwamstutz
Level 1
Level 1

‎08-03-2007 03:00 PM - edited ‎03-14-2019 10:56 PM

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?

Labels:
0 Helpful
2 Replies 2

gogasca
Level 10
Level 10

‎08-03-2007 06:51 PM

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

0 Helpful

rwamstutz
Level 1
Level 1
In response to gogasca

‎08-06-2007 04:29 AM

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?

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents