Logs

I can't get a 7.0 log to shrink. Can't I get it to shrink
if I do the following?
BACKUP LOG DBNAME WITH TRUNCATE_ONLY
Also: where does this backup go - into computer oblivion?That backup doesn't go anywhere. The log records that will be removed goes
into the "trash can". Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
Log File Grows too big
http://www.support.microsoft.com/?id=317375
Log file filling up
http://www.support.microsoft.com/?id=110139
Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"CLM" <anonymous@.discussions.microsoft.com> wrote in message
news:ea7501c3f0c7$ccc226e0$a401280a@.phx.gbl...
> I can't get a 7.0 log to shrink. Can't I get it to shrink
> if I do the following?
> BACKUP LOG DBNAME WITH TRUNCATE_ONLY
> Also: where does this backup go - into computer oblivion?|||That's what I thought but wanted to confirm.
And thx for the articles...
>--Original Message--
>That backup doesn't go anywhere. The log records that
will be removed goes
>into the "trash can". Check out below KB articles:
>INF: How to Shrink the SQL Server 7.0 Transaction Log
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;256650
>INF: Shrinking the Transaction Log in SQL Server 2000
with DBCC SHRINKFILE
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
>Log File Grows too big
>http://www.support.microsoft.com/?id=317375
>Log file filling up
>http://www.support.microsoft.com/?id=110139
>Considerations for Autogrow and AutoShrink
>http://www.support.microsoft.com/?id=315512
>http://www.mssqlserver.com/faq/logs-shrinklog.asp
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"CLM" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ea7501c3f0c7$ccc226e0$a401280a@.phx.gbl...
>> I can't get a 7.0 log to shrink. Can't I get it to
shrink
>> if I do the following?
>> BACKUP LOG DBNAME WITH TRUNCATE_ONLY
>> Also: where does this backup go - into computer
oblivion?
>
>.
>