Clear ldf files

You can shrink the log file if there is free space available in the log file , if it is in simple recovery model there should be free space and if it is in full recovery model either change it to simple recovery if you don't want to have full recovery in SQL2 server or take a log backup and then shrink file.

Why you want to create new LDF file? For a database both ldf and mdf are required so you shoudn't delete it. Sign in. United States English. Dalex Dalex 3, 18 18 silver badges 24 24 bronze badges. If you're looking to shrink just one file, use dbcc shrinkfile — Ben Thul. Perhaps yes, perhaps no. It all depends on what the database is waiting on to reuse log space. Maciej Niemir Maciej Niemir 5 5 silver badges 8 8 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions. The power of digital documents — on paper.

Real-time print analytics, insights and forecasts. From simply tracking and monitoring of print jobs, to integrating BYOD printing or advanced custom job management, PaperCut does it all. Discover what we do. All of this sounds great, but you really need to be geared up to support it.

You can do this by changing the recovery model to Simple. See the description here. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 4. Hot Network Questions. Question feed. Server Fault works best with JavaScript enabled. Accept all cookies Customize settings.