08-13-2009 05:08 AM - edited 03-15-2019 07:20 PM
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
08-13-2009 11:27 AM
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
08-17-2009 01:36 AM
Thanks Java,
I will apply the commands in our maintenance windows.
08-22-2009 03:01 AM
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
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: