Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EarlyWatch Alert report: Size of Transaction Log File of SBO-Common

Hi all,

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]:

297.02

My question is how much is the normal log size?

Thanks in advance,

Chief

replied

Hi Chief

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.

Kind regards

Peter Juby

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question