Reduce database log file size

M开发者_JAVA技巧y sql database .mdf file is 130mb and .ldf file is 1300mb. I want to reduce my .ldf file size. How can I do it and is there any problem occur after deleted data.

Thanks in advance

To start with, do a full backup, a log backup, and then set up scheduled log backups if you haven't done so already. After a few log backups you can shrink the log file and hopefully it won't grow that large again (unless you do some really unusual updates that touch a lot of data over and over again).

See http://msdn.microsoft.com/en-us/library/ms189275.aspx for more info on the different SQL Server recovery modes and backup requirements.