search cancel

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

book

Article ID: 112968

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

This is regarding the MDB database issue that we are facing. Currently the MDF Logs is around---219 GB
 

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

Resolution

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)