This is actually a good thing. Truncating the database transaction
log keeps the log size down as Microsoft doesn't do a good job
of maintaing their transaction log with SQL server:
CSCdz62507
Externally found moderate defect: Closed (C)
The log file for database CCM0303 is full. Backup the transaction
Full text of defect (~10K)
Summary of defect
View a new defect
Add a new enclosure
Modify the Release-note attachment.
Attachments: Release-note Description C-comments
Release-note: Added 021219 by wsisk
Symptoms:
CCM030x_log.ldf file grows above 1GB:
C:\MSSQL7\Data>dir
12/14/2002 07:13p 112,132,096 CCM0303.mdf
12/17/2002 02:04p 5,330,960,384 CCM0303_log.LDF
This message appears in event viewer:
Source: MSSQLServer
Event ID: 17052
Description:
Error: 9002, Severity: 17, State: 2
The log file for database 'CCM0303' is full. Back up the transaction log for
the database
to free up some log space.
Condidtions:
Callmanager 3.2(2c)spF. This occured on a backup callprocessing subscriber
node
hosting the 7960 phones and CTI registration for an IPCC environment
Workaround:
Backup the transaction log and then shrink the database
/Wes
> -----Original Message-----
> From: cisco-voip-bounces@puck.nether.net
> [mailto:cisco-voip-bounces@puck.nether.net]On Behalf Of Jeff Behl
> Sent: Wednesday, August 20, 2003 1:00 PM
> To: cisco-voip@puck.nether.net
> Subject: [cisco-voip] Database log truncated on callmanager 3.3(2)
>
>
> is anyone else experiencing this? this is the IP Telephony Backup job
> running. should I be concerned?
>
>
> Aug 19 21:00:13 10.1.2.11 cm-1.corp MSWinEventLog 2
> Application 8359 Tue
> Aug 19 21:00:13 2003 17055 MSSQLSERVER BackAdmin
> User Error CM-1CORP
> System Event 0000: 66 47 00 00 10 00 00 00 ......
> 0008: 09 00 00 00
> 43 00 4d 00 ...... 0010: 2d 00 31 00 43 00 4f 00 .... 0018: 52 00
> 50 00 00 00 08 00 ...... 0020: 00 00 43 00 43 00 4d 00 ..... 0028:
> 30 00 33 00 30 00 30 00 .... 0030: 00 00 00 00 50 00 00 00
> ....... 18278 : Database log truncated: Database: Ccm0300.
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip