cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
355
Views
5
Helpful
3
Replies

shrink CCM0301_log.LDF

iqadeer2e2
Level 1
Level 1

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

3 Replies 3

Jaime Valencia
Cisco Employee
Cisco Employee

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

HTH

java

if this helps, please rate

Thanks Java,

I will apply the commands in our maintenance windows.

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

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: