Due to the database being split between two files, 1) a .mdf and a 2) .ldf file, the .ldf file (log file) slowly increases with size over time, and once it becomes big enough, this would heavily impact the speed of how long a backup would take to process. To confirm whether the size of the log file does not exceed the recommended 500mb mark, please go to the following directory on your server computer:
1. On Windows 10, open "This PC". On other operating systems, go to My Computer.
2. Continue to the following directory: C: > Program Files > Microsoft SQL Server > MSSQL10.MSSQLSERVER > MSSQL > DATA
2. Once there, look for the name of your database, and look at the .ldf file - e.g. ExampleDatabaseName.ldf
3. Right-click on the file, and then click on properties.
4. Under "Size:" - make sure that the log file is not exceeding the 500mb mark.
5. If it is indeed bigger than 500mb - please contact Spiralsoft immediately in order for us to log in to your server computer via one of our support channels to shrink and clear the log file.
NOTE: Cleaning up the log file and making it smaller will in no way affect any transactional or any other type of data on your database.