shrink CCM0301_log.LDF

Unanswered Question
Aug 13th, 2009

Hi,

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)
Loading.
Jaime Valencia Thu, 08/13/2009 - 11:27

For CCM0301

C:\> osql -E

1>use CCM0301

2>go

1>backup log CCM0301 with no_log

2>go

1>dbcc shrinkdatabase (CCM0301)

2>go

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

HTH

java

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

Hi,

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.

1>"

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

Any suggestions?

TIA

Imtiaz

Actions

This Discussion