MIS Systems Thread, Solus3 Transaction Log Size in Technical; Just been looking at our Solus3 setup making sure everything is all sorted ready for the Summer Upgrade and noticed ...
13th July 2011, 08:13 PM #1
Solus3 Transaction Log Size
Just been looking at our Solus3 setup making sure everything is all sorted ready for the Summer Upgrade and noticed the database is 3MB but the Transaction Log size is 75MB. I ran full backups against it presuming that would trim the transaction log size down but it didn't.
Have I understood correctly that a full backup should trim the transaction log or is there another step and is 75MB large/small/normal for the Solus3 database?
IDG Tech News
13th July 2011, 08:50 PM #2
13th July 2011, 10:28 PM #3
Used SQL Backup and FTP from here: Free SQL backup software for MSSQL Server 2008 and MS SQL Server 2005 Express databases and did a Full backup using SQL Management Studio
Edit: Just noticed our Discover database is in a similar position (Database 100MB ish, log file 400MB ish) so obviously I'm missing something here. Did notice our Solus3 database is set to the Full recovery mode if that makes a difference. Discover and the rest of SIMS is set to simple.
Last edited by Cache; 13th July 2011 at 11:56 PM.
14th July 2011, 12:39 PM #4
Do a transaction log backup. Then you can do a backup and it should clean up. Need to have transaction logs backed up before it will mess with them.
If not, from management studio you can right click the db and from tasks use shrink file.
All at own risk of course!
14th July 2011, 08:41 PM #5
Thanks, will give it a shot tomorrow
14th July 2011, 11:19 PM #6
Did that today on my sims db.
Shrinkfile didn't work, but showed 90+% free.
Backup db didn't work.
Even though had done a transaction log backup yesterday.
Did another tran log backup and immediate shrinkfile and it went down from 1.4gb to 15mb.
15th July 2011, 08:25 PM #7
Got it sorted it in the end, just trying to get hold of the Discover Hosted Technical Guide now to view the details of the backup utility they now provide.
By albertwt in forum Enterprise Software
Last Post: 23rd February 2011, 11:21 PM
By secman in forum Windows
Last Post: 29th November 2005, 11:35 AM
By ChrisH in forum Windows
Last Post: 18th October 2005, 12:29 PM
By russdev in forum Downloads
Last Post: 29th July 2005, 08:19 PM
By mrtechsystems in forum Windows
Last Post: 26th June 2005, 10:50 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)