<!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">
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">
<title>CallManager Publisher - Out of Disk Space</title>
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2769" name="GENERATOR">
<div align="left" dir="ltr"><span class="906360603-03112005"><font
face="Tahoma" size="2">Here are the steps for shrinking the SQL
databases</font></span></div>
<div align="left" dir="ltr"><span class="906360603-03112005"></span> </div>
<div align="left" dir="ltr"><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 align="left" dir="ltr"><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" align="left" dir="ltr"
lang="en-us">
<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 align="left" dir="ltr"><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 align="left" dir="ltr"><span class="338520019-01112005"></span> </div>
<div align="left" dir="ltr"><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" align="left" dir="ltr"
lang="en-us">
<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 color="silver" face="Tahoma" 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 color="silver" face="Tahoma" 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 color="silver" face="Tahoma" 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 size="4" width="90%">
_______________________________________________
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>
</body>
</html>