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

Sun Nov 6 14:29:51 EST 2005

Thanks for the new feature.  Will this also show up in Unity?

________________________________

	From: Wes Sisk [mailto:wsisk at cisco.com] 
	Sent: Thursday, November 03, 2005 7:49 AM
	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

	Without backups the transaction log would (and has on several
systems) consume all avalable disk space.

	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.

	/Wes
	-----Original Message-----
	From: Carter, Bill [mailto:bcarter at sentinel.com]
	Sent: Wednesday, November 02, 2005 11:53 PM
	To: Wes Sisk
	Cc: Schuett, Court (MBNAP it); Stu Packett;
cisco-voip at puck.nether.net
	Subject: RE: [cisco-voip] CallManager Publisher - Out of Disk
Space

	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/20051106/9b2e64e6/attachment-0001.html