SQLserver日志文件太大 [英] SQLserver log files are too large

问题描述

嗨
我在SQL Server 2008中有一个数据库，并且正在虚拟主机中使用''

我注意到其日志文件已增加到20 GB，因此我不确定如何删除日志文件而不影响系统.

1.谁能告诉我如何删除日志文件或
2.如果我仅将日志大小限制为10 mb或其他东西，这会有所帮助吗?
3.我现在可以将其限制为10 mb吗，那里已经是20 gb文件

预先感谢您的回复

Bhaskar
[链接已删除]

Hi
I have a database in SQL Server 2008 and being used in web hosting''

I noticed its log file is increased to 20 GB, so I am not sure how to remove the log file without affecting the system.

1. Can anybody tell me how to remove the log file or
2. Will it be beneficial if I just restrict Log size to 10 mb or somthing
3. can I restrict now it to 10 mb where it is already 20 gb file

Thanks in advance for your response

Bhaskar
[Link removed]

推荐答案

查看此

否，我没有为我的问题找到正确的答案.

No i did not found the proper answer for my question..

EXEC SP_DBOPTION ''MYDBNAME'', ''trunc. log. on chkpt'', true

Bhaskar

Bhaskar

您需要缩小日志文件.

打开SSME
右键单击数据库
点击任务>
点击Srink>
点击文件>
选择文件类型作为日志
然后点击确定

You need to srink the log file.

Open SSME
Right click on database
click on Tasks >
Click on Srink >
click on Files >
choose file type as Log
and click ok

这篇关于SQLserver日志文件太大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！