delete unnecessary log & mdb files

[Anon Anon]

Hello everyone

  In my  CA servicedesk  server  c drive  is full  (165GB ) .

I want to  delete unnecessary log  files  but I don’t know which logs file are important .my CA patch manager is also  in theis server

 Plz help me

Thanku

Abhishek swarup

[e-mail]

9755928009

 

[Lindsay_Estabrooks]

Is this for Service Desk or Service Catalog? Have you determined which folders on the server are taking up space?

Here is a link to a Microsoft utility to help determine: http://technet.microsoft.com/en-us/sysinternals/bb896651.aspx

 

[Anon Anon]

Hi Abhishek,

In addition to what Lindsay had mentioned, it is better to perform the archive purge if the MDB and SDM application are on the same server followed by DBSHRINK. Below is the tech document for your reference about DBSHRINK:

https://comm.support.ca.com/?legacyid=TEC485866

Thanks,
Naveen

 

[Anon Anon]

 HI naveen

 

 https://comm.support.ca.com/?legacyid=TEC485866 . tech document not available

i think that problem is patch  manager  old patch download data storage

 

[Anon Anon]

Here is the content of TEC485866:

TITLE:

How to reduce the file size of two huge MDB database files mdb_log.LDF and mdb.mdf?

DESCRIPTION:

The file mdb_log.ldf is the transaction log, and the size of a transaction log can grow to be very large when there is no DB maintenance taking place. The solution helps you to shrink the size of this log file.

SOLUTION:

BACKUP LOG mdb WITH TRUNCATE_ONLY
DBCC SHRINKFILE(mdb_log, 5)
DBCC SHRINKDATABASE(mdb, TRUNCATEONLY)
 
Refer to these Microsoft knowledge base links for using the DBCC SHRINKFILE and SHRINKDATABASE commands:

http://support.microsoft.com/kb/907511
How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
 
http://www.support.microsoft.com/?id=272318
Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
 
Go through with Best Practices section of DBCC SHRINKDATABASE
http://msdn.microsoft.com/en-us/library/ms190488(SQL.90).aspx

Thanks,
Naveen

[Anon Anon]

hello

 

 C:\Program Files (x86)\CA\DSM  dsm folder usage  42GB space

and

C:\Program Files (x86)\CA\SC sc folder usage 60.34 GB  space

my mdb_log using only 1.gb space