<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>CallManager Publisher - Out of Disk Space</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<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><FONT face=Tahoma
size=2></FONT></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.</DIV></FONT></SPAN><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> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <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'; 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 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><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=338520019-01112005><FONT face=Verdana
size=2></FONT></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><FONT face=Verdana size=2></FONT> </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> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Stu
Packett<BR><B>Sent:</B> Tuesday, November 01, 2005 12:56 PM<BR><B>To:</B>
cisco-voip@puck.nether.net<BR><B>Subject:</B> [cisco-voip] CallManager
Publisher - Out of Disk Space<BR></FONT><BR></DIV>
<DIV></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 color=silver></FONT><FONT face=Tahoma size=1></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></BODY></HTML>