Over time, the log file gradually increases due to various reasons. The speed of the application might become affected by the size of the database's .ldf (log file), resulting in the application becoming slow due to the congested log file.
1. To determine if this is the case, please go to the following directory on your SERVER computer:
- "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA"
2. Look for the name of your database, which in this case we will refer to as "ExampleDatabase.ldf".
3. Right-click on your database's .ldf file, and click properties.
4. The size of this file should generally not exceed the 500mb mark, but would still be safe if it does go over this point.
5. If it exceeds the 500mb mark, please contact our support office in order to log a ticket so that one of our support agents can log in to your server computer and clear the log file for you. Clearing the log file will not affect any of your data, and you will not lose any important data relating to your business.