Home > Archive > microsoft.public.sqlserver.server > June 2002 > help re-sizing T-logs





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author help re-sizing T-logs
Terry

2002-06-22, 8:32 pm

My trans-logs have reached the "restrict to size" limits and some DTS jobs
are failing as a result. This DB serves up reports and has many transactions
recorded. How do I "reset" the logs or clear them? Thanks


Andrew J. Kelly

2002-06-22, 8:32 pm

If your using "Simple" recovery mode then you can issue: BACKUP LOG
YourLogName WITH TRUNCATE_ONLY. Otherwise backup the transaction log
normally.

--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.



"Terry" <tmaxturner@msn.com> wrote in message
news:O#49DmkECHA.2104@tkmsftngp02...
> My trans-logs have reached the "restrict to size" limits and some DTS jobs
> are failing as a result. This DB serves up reports and has many
transactions
> recorded. How do I "reset" the logs or clear them? Thanks
>
>


Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net