How to clean up transaction logs

Hello,
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
KitRefer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>