<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
it monitors for CCM and CDR database, unfortunately not ART so far.
Please let me know if anyone has a problem with transaction log size
after 4.1(3)sr1. if so and it turns out to be the ART transaction log,
we will look at adding that to the job.<br>
<br>
Unity does not take a similar approach thus far. They do have an SQL
job dedicated to trucate the transaction log daily, but it still does
not attempt to shrink the TL or database in case it has grown on a
transaction.<br>
<br>
/Wes<br>
<br>
Erick Bergquist wrote:
<blockquote
cite="mid20051106202313.90484.qmail@web34305.mail.mud.yahoo.com"
type="cite">
<pre wrap="">Is the new SQL job for the CCM database/logs only, or
does it monitor other databases also (CDR, ART)?
--- "Carter, Bill" <a class="moz-txt-link-rfc2396E" href="mailto:bcarter@sentinel.com"><bcarter@sentinel.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Thanks for the new feature. Will this also show up
in Unity?
________________________________
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Thursday, November 03, 2005 7:49 AM
To: Carter, Bill
Cc: Schuett, Court (MBNAP it); Stu Packett;
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: RE: [cisco-voip] CallManager Publisher -
Out of Disk
Space
Without backups the transaction log would (and has
on several
systems) consume all avalable disk space.
In all ES after 04.0(02a)ES33 04.1(02)ES26
04.1(03)ES01 there is
a new SQL job to monitor available disk space and if
it drops below 90%
then we automatically truncate and shrink the
transaction logs.
/Wes
-----Original Message-----
From: Carter, Bill [<a class="moz-txt-link-freetext" href="mailto:bcarter@sentinel.com">mailto:bcarter@sentinel.com</a>]
Sent: Wednesday, November 02, 2005 11:53 PM
To: Wes Sisk
Cc: Schuett, Court (MBNAP it); Stu Packett;
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: RE: [cisco-voip] CallManager Publisher -
Out of Disk
Space
You are right, something doesn't sound right. Is
there a "cap"
on the database/ldf log files. How large would it
grow if there was no
backups running??
________________________________
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Wednesday, November 02, 2005 10:14 PM
To: Carter, Bill
Cc: Schuett, Court (MBNAP it); Stu Packett;
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: Re: [cisco-voip] CallManager Publisher -
Out of
Disk Space
his databases appear relatively 'normal' in size.
Here
are sizes from some profiling I did:
Tests completed using CCM 3.2(2c)spF
I added 1000 phones to a system and associated
1000
users.
Without starting CCM and TFTP just the database
backup
file is 129MB.
My test included 1000 phones with 2 lines and 4
speed
dials each,
and a user associated with each phone.
Start CCM and TFTP service to genearte default
config
files
and the backup jumped up to 200MB for 1000 Users.
10,000 phones&users is ~10 times this size, or
1,280MB.
Scale for
a backup starting at 1GB that does not include
CDR's or
music-on-hold files.
1.5 Million CDR ~ 1,385,002 KB for CDR Database
/Wes
Carter, Bill wrote:
Here are the steps for shrinking the SQL
databases
From a command prompt
c:\osql -E
1> use CDR
2> go
1> backup log CDR with no_log
2> go
1> dbcc shrinkdatabase(CDR)
2> go
1>exit
You can also do this to the ART database. When
backups are run, the procedures have the same
affect.
________________________________
From: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[<a class="moz-txt-link-freetext" href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] On
Behalf Of Schuett, Court
(MBNAP it)
Sent: Tuesday, November 01, 2005 1:02 PM
To: 'Stu Packett';
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: RE: [cisco-voip] CallManager
Publisher - Out of Disk Space
I believe when you back it up, the
backup procedure goes through and compresses all
databases. I ran into
the same problem you're having one time and that
helped tremendously.
Are you running a backup every night? You can also
do it manually.
It's under the SQL Enterprise manager, but I don't
remember the exact
steps. Should be an article on cisco.com on how to
do it though.
Court Schuett
Network Systems Engineer
Millward Brown
Naperville, IL
630-955-8983
<a class="moz-txt-link-abbreviated" href="mailto:court.schuett@us.millwardbrown.com">court.schuett@us.millwardbrown.com</a>
________________________________
From: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[<a class="moz-txt-link-freetext" href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] On
Behalf Of Stu Packett
Sent: Tuesday, November 01, 2005 12:56
PM
To: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: [cisco-voip] CallManager
Publisher - Out of Disk Space
My CallManager Publisher ran out of disk
space. It had less than 1MB of free space when I
took a look at it.
I'm having a hard time regaining more disk space.
I've got over 1.6GB
now, but it's dropping. It's an MCS server (forgot
what model) with a
14.9GB C: drive partition. My art.mdf file is 2.9GB
and CDR.mdf is
1.5GB. The art_log.ldf is 70MB and CDR_LOG.ldf is
690MB. What else can
I do as I'm frequently getting the 'out of disk
space' warning in my
system logs. Thanks in advance.
Here's what I've done so far:
1. Delete all the C:\Program
Files\Cisco\Trace files
2. Delete all the IIS log files
3. Delete unncessary files that were
previously downloaded.
________________________________
IRS Circular 230 Disclosure: To ensure
compliance with requirements imposed by the IRS, we
inform you that any
U.S. federal tax advice in this communication
(including attachments) is
not intended or written by Fenwick & West LLP to be
used, and cannot be
used, for the purpose of (i) avoiding penalties
under the Internal
Revenue Code or (ii) promoting, marketing, or
recommending to another
party any transaction or matter addressed herein.
________________________________
ATTENTION:
The information contained in this
message may be legally privileged and confidential.
It is intended to
be read only by the individual or entity to whom it
is addressed or by
their designee. If the reader of this message is not
the intended
recipient, you are on notice that any distribution
of this message, in
any form, is strictly prohibited.
If you have received this message in
error, please immediately notify the sender and/or
Fenwick & West LLP by
telephone at (650) 988-8500 and delete or destroy
any copy of this
message.
====================================================
This email is confidential and intended solely for
the use of the
individual or organization to whom it is addressed.
Any opinions or
advice presented are solely those of the author and
do not necessarily
represent those of the Millward Brown Group of
Companies. If you are
not the intended recipient of this email, you should
not copy, modify,
distribute or take any action in reliance on it. If
you have received
this email in error please notify the sender and
delete this email
from your system. Although this email has been
checked for viruses
and other defects, no responsibility can be
accepted for any loss or
damage arising from its receipt or use.
====================================================
________________________________
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
<blockquote type="cite">
<pre wrap="">_______________________________________________
</pre>
</blockquote>
<pre wrap="">cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<pre wrap=""><!---->
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
<a class="moz-txt-link-freetext" href="http://mail.yahoo.com">http://mail.yahoo.com</a>
</pre>
</blockquote>
</body>
</html>