Utility to Delete EventLogs from SQL Data
With MV Tech's help we isolated the EventLogs data as the culprit swelling our SQL database so large we couldn't run the Transfer Table command. Using a SQL Mgmt Studio we Query "delete from EventLogs", Shrink the Data and we're good to go again. Even with about 9 months worth of work in the production database the dbase size is under 2gb. The EventLog had swollen to over 4gb and made creating a CE version for remote use impossible.
It would be very helpful to include a Utility in Database Mgmt to purge this data.
Rich
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.