<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><SPAN
class=404312819-06112005>Thanks for the new feature. Will this also show
up in Unity?</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Wes Sisk [mailto:wsisk@cisco.com]
<BR><B>Sent:</B> Thursday, November 03, 2005 7:49 AM<BR><B>To:</B> Carter,
Bill<BR><B>Cc:</B> Schuett, Court (MBNAP it); Stu Packett;
cisco-voip@puck.nether.net<BR><B>Subject:</B> RE: [cisco-voip] CallManager
Publisher - Out of Disk Space<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=307554513-03112005><FONT face=Arial color=#0000ff
size=2>Without backups the transaction log would (and has on several
systems) consume all avalable disk space.</FONT></SPAN></DIV>
<DIV><SPAN class=307554513-03112005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=307554513-03112005><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=307554513-03112005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=307554513-03112005><FONT face=Arial color=#0000ff
size=2>/Wes</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Carter, Bill
[mailto:bcarter@sentinel.com]<BR><B>Sent:</B> Wednesday, November 02, 2005
11:53 PM<BR><B>To:</B> Wes Sisk<BR><B>Cc:</B> Schuett, Court (MBNAP it); Stu
Packett; cisco-voip@puck.nether.net<BR><B>Subject:</B> RE: [cisco-voip]
CallManager Publisher - Out of Disk Space<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=154385104-03112005><FONT face=Tahoma
size=2>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??</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Wes Sisk [mailto:wsisk@cisco.com]
<BR><B>Sent:</B> Wednesday, November 02, 2005 10:14 PM<BR><B>To:</B> Carter,
Bill<BR><B>Cc:</B> Schuett, Court (MBNAP it); Stu Packett;
cisco-voip@puck.nether.net<BR><B>Subject:</B> Re: [cisco-voip] CallManager
Publisher - Out of Disk Space<BR></FONT><BR></DIV>
<DIV></DIV>his databases appear relatively 'normal' in size. Here are
sizes from some profiling I did:<BR><BR><PRE wrap="">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</PRE>/Wes<BR><BR>Carter,
Bill wrote:
<BLOCKQUOTE
cite=mid6A0744639B86DD459433108DBF101D26A433D7@MAIL01.sentinel.com
type="cite">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<DIV dir=ltr align=left><SPAN class=906360603-03112005><FONT face=Tahoma
size=2>Here are the steps for shrinking the SQL
databases</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906360603-03112005></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906360603-03112005><FONT face=Tahoma
size=2>From a command prompt<BR>c:\osql -E<BR>1> use CDR<BR>2>
go<BR>1> backup log CDR with no_log<BR>2> go<BR>1> dbcc
shrinkdatabase(CDR)<BR>2> go<BR>1>exit<BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906360603-03112005><FONT face=Tahoma
size=2>You can also do this to the ART database. When backups are
run, the procedures have the same affect.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> <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>]
<B>On Behalf Of </B>Schuett, Court (MBNAP it)<BR><B>Sent:</B> Tuesday,
November 01, 2005 1:02 PM<BR><B>To:</B> 'Stu Packett'; <A
class=moz-txt-link-abbreviated
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><B>Subject:</B>
RE: [cisco-voip] CallManager Publisher - Out of Disk
Space<BR></FONT><BR></DIV>
<DIV dir=ltr align=left><SPAN class=338520019-01112005><FONT
face=Verdana size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=338520019-01112005></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN
class=338520019-01112005></SPAN> </DIV>
<DIV> </DIV>
<DIV align=left><FONT face="Comic Sans MS" size=4><EM>Court
Schuett</EM></FONT></DIV>
<DIV align=left><FONT face=Verdana size=2>Network Systems
Engineer</FONT></DIV>
<DIV align=left><FONT face=Verdana size=2>Millward Brown</FONT></DIV>
<DIV align=left><FONT face=Verdana size=2>Naperville, IL</FONT></DIV>
<DIV align=left> </DIV>
<DIV align=left><FONT face=Verdana size=2>630-955-8983</FONT></DIV>
<DIV align=left><FONT face=Verdana size=2><A
href="mailto:court.schuett@us.millwardbrown.com">court.schuett@us.millwardbrown.com</A></FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> <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>]
<B>On Behalf Of </B>Stu Packett<BR><B>Sent:</B> Tuesday, November 01,
2005 12:56 PM<BR><B>To:</B> <A class=moz-txt-link-abbreviated
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><B>Subject:</B>
[cisco-voip] CallManager Publisher - Out of Disk
Space<BR></FONT><BR></DIV>
<DIV><!-- Converted from text/rtf format -->
<P><FONT face=Tahoma size=2>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.</FONT></P>
<P><FONT face=Tahoma size=2>Here's what I've done so far:</FONT> </P>
<P><FONT face=Tahoma size=2>1. Delete all the C:\Program
Files\Cisco\Trace files</FONT> <BR><FONT face=Tahoma size=2>2.
Delete all the IIS log files</FONT> <BR><FONT face=Tahoma
size=2>3. Delete unncessary files that were previously
downloaded.</FONT> </P></DIV>
<DIV>
<HR>
</DIV>
<DIV><FONT face=Tahoma color=silver size=2>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.</FONT> </DIV>
<DIV><FONT face=Tahoma color=silver size=1>
<HR>
ATTENTION:<BR>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.</FONT> </DIV>
<DIV><FONT face=Tahoma color=silver size=1>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.</FONT> </DIV><BR><BR>
<TABLE style="COLOR: black" bgColor=white>
<TBODY>
<TR>
<TD><BR><BR>==================================================== <BR>This email is confidential and intended solely for the use of the <BR>individual or organization to whom it is addressed. Any opinions or <BR>advice presented are solely those of the author and do not necessarily <BR>represent those of the Millward Brown Group of Companies. If you are <BR>not the intended recipient of this email, you should not copy, modify, <BR>distribute or take any action in reliance on it. If you have received <BR>this email in error please notify the sender and delete this email <BR>from your system. Although this email has been checked for viruses <BR> and other defects, no responsibility can be accepted for any loss or <BR>damage arising from its receipt or use. <BR>==================================================== <BR></TD></TR></TBODY></TABLE></BLOCKQUOTE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
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></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>