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"
精彩评论