[sims] Solus3 Transaction Log Size

[Cache]

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

[matt40k]

And how did you backup?

[Cache]

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.

Edited July 13, 2011 by Cache

[vikpaw]

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!

[Cache]

Thanks, will give it a shot tomorrow

[vikpaw]

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.

[Cache]

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