[cisco-voip] CallManager Publisher - Out of Disk Space
Erick Bergquist
erickbe at yahoo.com
Sun Nov 6 15:23:12 EST 2005
Is the new SQL job for the CCM database/logs only, or
does it monitor other databases also (CDR, ART)?
--- "Carter, Bill" <bcarter at sentinel.com> wrote:
> 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
>
>
> > _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
More information about the cisco-voip
mailing list