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"

Reply via email to