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) - Start the Eventlog Analyzer.
Note: This process will take some time, based on the EventLog Analyzer database size.
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?