+ Post New Thread
Results 1 to 7 of 7
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 ...
  1. #1
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,187
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63

    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?

    Thanks

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,338
    Thank Post
    367
    Thanked 622 Times in 508 Posts
    Rep Power
    155
    And how did you backup?

  3. #3
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,187
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    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 10:56 PM.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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!

  5. Thanks to vikpaw from:

    Cache (14th July 2011)

  6. #5
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,187
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    Thanks, will give it a shot tomorrow

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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.

  8. #7
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,187
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    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.

    Cheers Vikpaw

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 7
    Last Post: 23rd February 2011, 10:21 PM
  2. Windows XP Boot Log
    By secman in forum Windows
    Replies: 36
    Last Post: 29th November 2005, 10:35 AM
  3. Replies: 2
    Last Post: 18th October 2005, 11:29 AM
  4. Log Parser
    By russdev in forum Downloads
    Replies: 4
    Last Post: 29th July 2005, 07:19 PM
  5. Event Log Every 5 Mins in Windows 2k Server
    By mrtechsystems in forum Windows
    Replies: 11
    Last Post: 26th June 2005, 09:50 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •