开发者

How to reduce ldf file size if we have applied replication on database

I have a Database that is using replication. Now I want to reduce the LDF file size (currently the size of the LDF is 6 GB).

I did "shrink" the LDF files, but it shrank only a few MBs. We need to look for other options for it because these database are using replication. Is any solution availa开发者_如何学Cble for it?


You should change database recovery model to "simple" and then use

dbcc shrinkdatabase('database_name').

After this you will have an empty log.

Then do not forget to change recovery model back to "Full"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜