EarlyWatch Alert report: Size of Transaction Log File of SBO-Common
I have run the EarlyWatch Alert after that we got a report about waning of the Size of Transaction Log File of SBO-Common.
Transaction Log Path:
Transaction C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SBO-COMMON_log.LDF
Log Size [MB]:
My question is how much is the normal log size?
Thanks in advance,
Peter Juby replied
Do a backup of the transaction log, not database, and make sure truncate is ticked. Then right click database and select shrink files. Select transaction log from the drop down list and click on OK. You will not see a drop in the size immediately, and might need to run this in the evening, but it will eventually reduce the size.