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

[Carter, Bill]

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. 
==================================================== 
	

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