shrink CCM0301_log.LDF

Unanswered Question
Aug 13th, 2009
User Badges:

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
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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
User Badges:

Thanks Java,


I will apply the commands in our maintenance windows.

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

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