开发者

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

开发者 https://www.devze.com 2023-02-28 23:26 出处:网络
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 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

精彩评论

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

关注公众号