title: Remove existing log file and create new log file in sql server
body: <p>I have log file which is grown to 1TB. I have no need of log file. Just want to delete the old log file and create a new one instead of old log file.</p>
  
  <p>How can I achieve that ? will it cause any other problem? pleas help.</p>