Currently the MDF Logs is around---219 GB whats the impact if the logs are removed from db

Document ID : KB000112968
Last Modified Date : 04/09/2018
Show Technical Document Details
Introduction:
This is regarding the MDB database issue that we are facing. Currently the MDF Logs is around---219 GB
 
Question:
Currently the MDF Logs is around---219 GB whats the impact if the logs are removed from db-- whats the information stored in the MDB logs. what Information is lost when logs are deleted. Will the archived incidents be retrieved if the logs are deleted.logs.
Environment:
Windows 2012
Sql Server 2012
Answer:
From the application, if we delete data from the tables, we are necessary recovering the space

The size could be reduced by database shrink

Launch Sql Studio Management , logon as administrator or sa

Right click on the mdb database -> task -> shrink -> database  (OK) 

Right click on the mdb database -> task -> shrink -> file -> file_type=data (OK) 
Right click on the mdb database -> task -> shrink -> file -> file_type=log (OK) 
Right click on the mdb database -> task -> shrink -> file -> file_type=FILESTREAMDATA (OK)