acronis_cms_stats_log database is growing out of control

Thread needs solution
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Contributions: 2
Commentaires: 3

We are seeing issues where the logs for the acronis_cms_stats database (sql server 2005 running on a different machine) are growing beyond a reasonable size. I've found the article for cleaning up the acronis_cms_cards_log and it worked wonderfully. I've changed the backup options to 'simple' (instead of full) but I can't find any information on shrinking the acronis_cms_stats database (more specifically the logs file).

mar 29/11/2011 - 17:06
0 Users found this helpful
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Contributions: 2
Commentaires: 3

I found this helpful for anybody else who has the same issue:

How do I truncate the SQL Transaction logs?

The information in this article applies to:

GFI MailArchiver 2011 for Exchange
GFI MailArchiver for Exchange 3
GFI MailArchiver for Exchange 4
GFI MailArchiver for Exchange 5
GFI MailArchiver for Exchange 6

Article ID: KBID003872

Query keywords: database, sql, transaction log

When using GFI MailArchiver, the Microsoft SQL backend databases may grow to be very large in size. One reason this can happen is because Microsoft SQL Server keeps a list of all transactions in the database Transaction Logs. You may want to truncate the transaction logs so as to save space.

To truncate the transaction logs in Microsoft SQL Server 2005/2008:

1. Open SQL Enterprise Management Studio
2. Login to the instance where you have the GFI MailArchiver databases using the 'sa' credentials
3. Expand the Instance name > Databases
4. Right click on the database name, select Tasks > Shrink > Files
5. Under File Type select Log
6. Under “Shrink Action” select “Reorganize pages before releasing unused space” and click OK.

mar 29/11/2011 - 17:09