shrink CCM0301_log.LDF

Unanswered Question
Aug 13th, 2009


We've running Callmanager ver 4.2(3) and BARS has been failing due to not having enough hdd space on the C drive. The CCM0301_log.LDF transaction log file is over 15GB!!

Is there a way to shrink the file?

CCM0301 database setting are as follows:

Recovery mode=Full

Transaction Log file setting set to "automatically grow file" with "unrestricted file growth"

Thanks in advance

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Jaime Valencia Thu, 08/13/2009 - 11:27

For CCM0301

C:\> osql -E

1>use CCM0301


1>backup log CCM0301 with no_log


1>dbcc shrinkdatabase (CCM0301)


Also i'd recommend to change the unrestricted file growth to a fixed size to avoid this.

Once you're able to run BARS it will truncate the log so it's a good idea to program a backup every once in a while



if this helps, please rate

iqadeer2e2 Mon, 08/17/2009 - 01:36

Thanks Java,

I will apply the commands in our maintenance windows.

iqadeer2e2 Sat, 08/22/2009 - 03:01


When typing the required commands I got the following message below.

"C:\>osql -E

1> use CCM0301

2> go

1> backup log CCM0301 with no_log

2> go

The log was not truncated because records at the beginning of the log are

pending replication. Ensure the Log Reader Agent is running or use sp_repldone

to mark transactions as distributed.


I've not type the dbcc shrink command as I wasn't sure whether to carry on.

Any suggestions?




This Discussion