问题描述:

My 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.

相关阅读:
Top