what is the best way of get rid of the log file from subscription database. it is growing big in production db. and i want to make it simple so that it'll not grow further.
shall i deattach & attach again without log file so that a new log file will be created by sql server?
is that a good practice?