>Hi all,
>
>How can I reduce the MS SQL server 2000's log file? I started to use SQL Server in january, in July, the log file was about 250Mo and last week it was about 5Go. I found how to limit its expension, but I'd like to reduce its size without loosing datas.
>
>Any help welcome
Take a look at transact SQL command BACKUP LOG. Check this command's help topic. There is an option to TRUNCATE_ONLY the database.
You might want to check DBCC SHRINKDATABASE command as well.
Hector Correa