Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

shrink CCM0301_log.LDF

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
Cisco Employee

Re: shrink CCM0301_log.LDF

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

www.cisco.com/go/pdi
New Member

Re: shrink CCM0301_log.LDF

Thanks Java,

I will apply the commands in our maintenance windows.

New Member

Re: shrink CCM0301_log.LDF

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

153
Views
5
Helpful
3
Replies
CreatePlease login to create content