Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to clear a Transaction Log?
0 views
Skip to first unread message
Gerald Jensen
Apr 7, 2001, 1:29:57 PM4/7/01
to
One of my SQL Server 7 clients has a database that is only 20mb in size, but
has a Transaction Log that is almost 1.5gb!
has a Transaction Log that is almost 1.5gb!
Whoever installed the server didn't bother to turn on Auto Shrink or
Truncate on Chk Pt, and it has been running (with no backups!) for about 15
months.
We turned autoshrink and truncate on chk pt both on, but so far there has
been no shrinkage in the log file. They don't have a crisis today, but with
only 3gb free will run out of space in a few weeks if we don't get this
under control.
Any suggestions/advice would be appreciated.
G. Jensen
Drewbert
Apr 8, 2001, 2:36:21 AM4/8/01
to
This transaction log may have auto-grow turned on, but not quto-shrink. If
this is the case, the log will never shrink itself, regardless of how empty
it becomes.
"Gerald Jensen" <gje...@autodatasys.com> wrote in message
news:r9Iz6.45$aJ6....@feed.centurytel.net...
this is the case, the log will never shrink itself, regardless of how empty
it becomes.
"Gerald Jensen" <gje...@autodatasys.com> wrote in message
news:r9Iz6.45$aJ6....@feed.centurytel.net...
SMD, Sky
Apr 17, 2001, 10:45:59 AM4/17/01
to
Hi Gerald,
Did you try
dump transaction DatabaseName with truncate_only
or
dump transaction DatabaseName with no_log
Check books online for more info.
Hope it helps,
Ed
"Gerald Jensen" <gje...@autodatasys.com> wrote in message
news:r9Iz6.45$aJ6....@feed.centurytel.net...
0 new messages