Track-It! Database 101: Transaction Logs and Recovery Model provides insight into Transaction log's impact to the Application's performance from a Database perspective and related terminology.
NOTE: The actual size of the transaction log isn't necessarily a problem. It is the amount of free space available in the transaction log that really makes a difference when it comes to database performance. If you simply want to reduce the size of the log, the steps below can be taken:
- On the SQL Server, or a machine that has the database administration tools installed, start SQL Server Management Studio.
- Connect to the Track-It! database server and login with an SysAdmin (SA) or equivalent account.
- Right-click the Track-It! 20xx database and select Tasks -> Back Up.
- Take note of the recovery model of the database. Set the Recovery type to 'SIMPLE'
- Click Ok to begin the transaction log backup.
NOTE: A full backup must have been done prior to backing up the transaction log, or the backup will fail. Following article shall assist with taking a Full Backup of the 20xx Database:
How to backup Track-It! 2020 database
- Once the backup is complete, click Ok.
- Next, right-click the database again and select Tasks -> Shrink -> Files.
- Select "Log" from the File Type drop down list, and then click Ok.
If the
actual size of the transaction log was not reduced by the above process and you want to force it to a smaller size, the following steps shall assist with this:
- Right-Click on the Track-It 20xx Database from within SQL server Management Studio and then click on Properties. Then click on the 'Options' Menu from the left hand side navigation pane within the Properties Window. Once that is up, you should see a Recovery Model drop down. Change that to Simple.
- Then, Right-Click on the Track-It Database and select Tasks -> Shrink -> Files. From the "File Type" select "Log". Make sure "Release Unused Space" is Checked under "Shrink Action" and then hit OK.
- Then, Right-Click on the Track-It Database again then click on Properties. Then click on the 'Options' Menu from the left hand side navigation pane within the Properties Window. Once that is up, you should see a Recovery Model drop down. Change that to back to Full. If you'd like to you can leave it at Simple, Track-It! Database 101: Transaction Logs and Recovery Model shall help you make the call.
After shrinking the size of the transaction log, if you
require "point-in-time" recovery of the database make sure to set the
Recovery model back to 'Full' and
create a new full backup so that new transaction log backups can be created.