How can i reduce the size of LDF File

[neoklis]

Hi

I have a db which's LDF File is 64GB and the mdf file is 554MB. I want to reduce the size of LDF file. Is it risky and how can i do this; I 've tried the shrink database and file wizard but with no results. I am workink on Sql Server 2000.

Thanks

 

[SQL_Hell]

64gb how on earth did it get that big?

Are you backing this database up?

To shrink the log run the following

CHECKPOINT BACKUP LOG mydatabase WITH TRUNCATE_ONLY

then run


DBCC SHRINKFILE ('mydatabase_log', 1)

you need to change the database name and the logical log file name in the statements

 

[neoklis]

Thanks for your response.

It get so big because we are daily importing 40-42 tables from SAP.

I want to reduce the size so i will be able to back it up

Could you please tell me where to type the previous commands;

 

[neoklis]

I am done with this. Thanks for the assistance