Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
delete transaction log
- Thread starter ktucci
- Start date
tlbroadbent
MIS
You can't delete the Transaction Log. It is required. However, if you mean "How Do I Remove Records From the Transaction Log" or "How Do I Shrink the Transaction Log" see faq183-1534.
Please let me kow if this answers your question. If not, please clarfy. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Thread starter
- #3
yes..i meant truncate or shrink the transaction log...the simple solution that worked for now was to dettach the db then delete the transaction log then reattach the db and create an empty transaction log...the reason for this is because my trans log grows to 45 gbs on a daily basis...probably mostly to bad sql techniques but none the less it has become a problem
thanks for your help
keith
thanks for your help
keith
- Status
Similar threads
- Locked
- Question