What type of database is it? If it's a Microsoft SQL database, I believe your DBA is asking you to truncate the transaction log.
Truncating the transaction log removes all inactive transactions (transactions already committed) from the log. This alone, however, does not reduce the size of the transaction log. To reduce the size, you must first truncate it and then shrink it using DBCC SHRINKFILE. See the following article for more info: http://support.microsoft.com/kb/873235 Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, November 26, 2007 10:42 AM To: [email protected] Subject: Database not releasing space even after all records have been deleted Hi: The diskspace keeps showing high usage even after I have deleted all records from all of the forms in my remedy instance. DBA is asking me to run a truncate. But I remember being told in remedy training not do do anything from sql prompt. I saw one email (http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0709&L=arslist&P=R220861 &I=-3&X=23F4FB0752F26A51E6&Y=ravinm%40cox.net) which does run steps from the sql prompt. Can someone confirm if i can actually run these (copy to a temp table, truncate the original table and copy the stuff back to the orginal table) from sql prompt without impacting Remedy operations? TIA Ravi ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

