Re: CDR_log.LDF huge size

It may take a while but you can still enable BARS to back up
your  
CDRs.   If your transaction log is filling up that quickly
then it  
sounds like you have a pretty hefty call volume and you have
hit he  
max amount of CDR records so Aupair is having to delete a
lot of them  
to bring you back down.   The max records by default is 1.5
million  
and is set via a service parameter for Database Layer
Monitor (aka  
Aupair).

There is a SQL job that will truncate the logs as well but
it only  
triggers if the c: drive gets below 500Mb free space.

-Ryan

On Jan 31, 2007, at 8:54 AM, Ruben Montes ((Europe)) wrote:

Hi,

BARS is actually not backing up the CDR. Can I still
configure it now  
or it's too late due to the size of the file?

Thanks,

Ruben

De: Joe Pollere (US) [mailto:Joe.Pollereus.didata.com]
Enviado el: mié 31/01/2007 13:59
Para: Ruben Montes (Europe); cisco-voippuck.nether.net
Asunto: RE: [cisco-voip] CDR_log.LDF huge size

Ruben,


You need to truncate the log file. There is a sql command to
do it.  
Alternatively if you back up with BARS select CDR and BARS
will  
truncate for you as part of the backup process.


Joe


From: cisco-voip-bouncespuck.nether.net
[mailto:cisco-voip- 
bouncespuck.nether.net] On Behalf Of Ruben Montes (Europe)
Sent: Wednesday, January 31, 2007 4:54 AM
To: cisco-voippuck.nether.net
Subject: [cisco-voip] CDR_log.LDF huge size


Hi,

I have noticed that my CDR_log.LDF file, that is located in
C: 
Program FilesMicrosoft SQL ServerMSSQLData has a size of
32GB and  
is growing 5GB per week. I suppose there should be a bug
behind, but  
the for the moment I want to stop this growing...

Do you know if it is enough with putting the service
parameter CDR  
Enabled flag to false to stop collecting CDR information?
Later on  
I'll see how we will purge this because I assume it will be
a CPU  
intensive process...

I have a TAC case opened, but for the moment the engineer it
is not  
helping me very much...

Regards,

Ruben

_______________________________________________
cisco-voip mailing list
cisco-voippuck.nether.net
h
ttps://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voippuck.nether.net
h
ttps://puck.nether.net/mailman/listinfo/cisco-voip

Yup, that looks like it's directly taken from Wes' old bug


Note that the db shrink will take a while to execute on a
32Gb  
transaction log.

-Ryan

On Jan 31, 2007, at 9:36 AM, Ruben Montes ((Europe)) wrote:

Hi,

if I execute the following commands will I reduce the size
of this file?

osql -E
1> use cdr
2> go
1> backup log cdr with no_log
2> go
1> dbcc shrinkdatabase(cdr)
2> go
1>exit

Thanks,

Ruben

De: Ryan Ratliff [mailto:rratliffcisco.com]
Enviado el: mié 31/01/2007 15:32
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voippuck.nether.net
Asunto: Re: [cisco-voip] CDR_log.LDF huge size

It may take a while but you can still enable BARS to back up
your
CDRs.   If your transaction log is filling up that quickly
then it
sounds like you have a pretty hefty call volume and you have
hit he
max amount of CDR records so Aupair is having to delete a
lot of them
to bring you back down.   The max records by default is 1.5
million
and is set via a service parameter for Database Layer
Monitor (aka
Aupair).

There is a SQL job that will truncate the logs as well but
it only
triggers if the c: drive gets below 500Mb free space.

-Ryan

On Jan 31, 2007, at 8:54 AM, Ruben Montes ((Europe)) wrote:

Hi,

BARS is actually not backing up the CDR. Can I still
configure it now
or it's too late due to the size of the file?

Thanks,

Ruben

De: Joe Pollere (US) [mailto:Joe.Pollereus.didata.com]
Enviado el: mié 31/01/2007 13:59
Para: Ruben Montes (Europe); cisco-voippuck.nether.net
Asunto: RE: [cisco-voip] CDR_log.LDF huge size

Ruben,


You need to truncate the log file. There is a sql command to
do it.
Alternatively if you back up with BARS select CDR and BARS
will
truncate for you as part of the backup process.


Joe


From: cisco-voip-bouncespuck.nether.net
[mailto:cisco-voip-
bouncespuck.nether.net] On Behalf Of Ruben Montes (Europe)
Sent: Wednesday, January 31, 2007 4:54 AM
To: cisco-voippuck.nether.net
Subject: [cisco-voip] CDR_log.LDF huge size


Hi,

I have noticed that my CDR_log.LDF file, that is located in
C:
Program FilesMicrosoft SQL ServerMSSQLData has a size of
32GB and
is growing 5GB per week. I suppose there should be a bug
behind, but
the for the moment I want to stop this growing...

Do you know if it is enough with putting the service
parameter CDR
Enabled flag to false to stop collecting CDR information?
Later on
I'll see how we will purge this because I assume it will be
a CPU
intensive process...

I have a TAC case opened, but for the moment the engineer it
is not
helping me very much...

Regards,

Ruben

_______________________________________________
cisco-voip mailing list
cisco-voippuck.nether.net
h
ttps://puck.nether.net/mailman/listinfo/cisco-voip


_______________________________________________
cisco-voip mailing list
cisco-voippuck.nether.net
h
ttps://puck.nether.net/mailman/listinfo/cisco-voip