当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server - Reduce database log file size

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: