Shrinking the SalesLogix Log File in SQL2005


When the SQL Recovery model is set to “Full” this setting keeps older log records in the file for the most detailed recovery.   This setting can create extremely large log files which may not be needed. 

Try the procedure below via SQL Server Management Studio to fully shrink the log file:

      1. Right click on the database and select “Tasks>Back Up” from the local menu to bring up the “Back Up Database” screen.
2. On the “General” page, change the “Backup type” from “Full” to “Transaction Log”.
3. On the “General” page, add a “Destination” for the file and select it.
4. On the “Options” page, ensure that the “Truncate the transaction file” option is selected and click the OK button.
5. After the backup has completed, go to the “Properties” screen for the database.
6. On the “Options” page, change the “Recovery model” from “Full” to “Simple”.
7. Close the “Properties” screen.
8. Right click on the database and select “Tasks>Shrink>Files” from the local menu to bring up the “Shrink File” screen.
9. Change the “File type” from “Data” to “Log”.
10. Ensure that the “Release unused space” option is selected and click the OK button.
11. When done close the “Shrink File” screen and open the “Properties” screen.
12. On the “Options” page, change the “Recovery model” from “Simple” back to “Full”.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!