Dear experts, Please suggest how to handle or prevent the increasing size of SSRS Log file in DB.
That’s a google question friend.
1 Like
I know it is google question. But, I am new to epicor and doing first time. So, I am afraid that if we shrink the database, then it will not get worse. Because this is live database.
Again SQL Management is completely separate from Epicor. Epicor uses MSSQL so MSSQL best practices apply. The reason your DB is growing so much is because you have it in Full Recovery mode and you aren’t taking proper backups to trim the log.
This can all be corrected with appropriate backups and proper DB maintenance, but again this isn’t an EPICOR issue is a MSSQL issue.
Frankly if we tell you how to fix it we’d be doing you and your company a disservice. If you do not know or do not understand the implications I HIGHLY recommend you hire or find someone qualified to handle this in your company running SQL and managing a database without the basic understand is dangerous.
I recommend getting familar with SQL Best practices if you are in charge of administering a Database, getting also acquainted with Brent Ozar and his team may be a good idea.
1 Like