Truncating SQL Logs

Truncating SQL Logs

We are using ELA 11 and our database is stored on a separate SQL 2012 server.  We have a couple of maintenance plans that run every night I would like to add the ELA database too.  My questions are:

1. Can I just run a basic log truncate (DBCC SHRINKFILE) with the name of the database log file and the size to shrink the log file down too or do I need to follow other steps?  On this page  https://www.manageengine.com/products/eventlog/help/help-menu/eventlog-tips.html the following is listed if the transaction logs are full and I would like to make sure those exact steps do not need to be followed:

 If the EventLog Analyzer MS SQL database transaction logs are full, shrink the same with the procedure given below: 

  • Stop the Eventlog Analyzer Server/Service (Check the Eventlog Analyzer server machine's Task Manager to ensure that the processes 'SysEvtCol.exe', 'Java.exe' are not running).
  • Connect MS SQL client (using Microsoft SQL Server Management Studio) and execute the below query:

    sp_dboption 'eventlog', 'trunc. log on chkpt.', 'true'

    To execute the query, select and highlight the above command and press F5 key.
  • After executing the above command, select and highlight the below command and press F5 key to execute it.

    DBCC SHRINKDATABASE (eventlog)

  • Note: This process will take some time, based on the EventLog Analyzer database size.

  • Start the Eventlog Analyzer.
2. I also have a maintenance plan that runs every night and performs the following tasks on our databases: Database Integrity Check, Reorganize Indexes and Update Statistics.  If I add the ELA database to this maintenance plan is that ok or will it cause any issues with the database? 


              New to ADManager Plus?

                New to ADSelfService Plus?