[cisco-voip] CallManager Publisher - Out of Disk Space

[Carter, Bill]

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 [mailto:wsisk at cisco.com] 
	Sent: Wednesday, November 02, 2005 10:14 PM
	To: Carter, Bill
	Cc: Schuett, Court (MBNAP it); Stu Packett;
cisco-voip at puck.nether.net
	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: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Schuett, Court
(MBNAP it)
			Sent: Tuesday, November 01, 2005 1:02 PM
			To: 'Stu Packett'; cisco-voip at puck.nether.net
			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
			court.schuett at us.millwardbrown.com
			 

________________________________

			From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Stu Packett
			Sent: Tuesday, November 01, 2005 12:56 PM
			To: cisco-voip at puck.nether.net
			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
		cisco-voip at puck.nether.net
		https://puck.nether.net/mailman/listinfo/cisco-voip
		  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20051102/83306dc8/attachment-0001.html