Try to make a bit clearify.
I have a lot of trouble because of my avast_log.LDF is growing very quickly. Now it's about 2,5 GB !!!
The database avast.mdf is normal sized.
I need to drop the .ldf, because it's growing so fast to hang my system. We don't know why.
I did as you suggest. Since 23/7, the tx log has increased more than 500 MB !!
I try to:
1. back up the database
2. delete the files (bot ldf and mdf)
3. restore the database
but unsuccessfully.
We could not restore the database, even with avast Management Server service stopped.
I use the AMS tool, database management to restore the database, but I got several errors, like
Cannot execute internal SQL command 0x80040E14
No permission to access the database avast
I need support.
What' s the correct path?
Do I need to backup both database mdf and tx log and how often ?
Thanks
Sergio