SQL Server – Clear Log File

sql server

After some research i found a very simple solution

Try following steps

1. change mode from FULL to Simple.
2. Right-click the DB & in shrink option, shrink only log files.
3. revert the mode to Full.

You will certainly see lot of difference in size of log files.

Leave a Reply

Your email address will not be published.