<!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><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></BODY></HTML>