What I need is some guidance on either compressing that database or clearing some records.

Hi Ron,

If you're unable to select the farm name from the drop down menu on the Purge Historical Activity screen of ControlPoint, you can manually do the same process by following the "Transaction Log of xcAdmin database" KB article.

The basic gist of the operations is the following:

1. In SQL Server Management Studio, right click on the xcAdmin database and select Properties
2. Click on Options and set the Recovery Model to Simple, hit OK to save
3. Right click on the xcAdmin database again and shrink the database or the log file

You can also shrink the log file by running the following SQL Query against the xcAdmin database:

Use xcAdmin

DBCC SHRINKFILE(xcAdmin_log, 10)

BACKUP LOG xcAdmin WITH TRUNCATE ONLY

DBCC SHRINKFILE(xcAdmin_log, 10)

Link to KB article from Cyrus' original post is: metalogix.force.com/.../Transaction-log-of-xcAdmin-database-consumes-disk-space

Good luck and please let us know how it goes, thanks!

-Siam

Hi Ron,

If you're unable to select the farm name from the drop down menu on the Purge Historical Activity screen of ControlPoint, you can manually do the same process by following the "Transaction Log of xcAdmin database" KB article.

The basic gist of the operations is the following:

1. In SQL Server Management Studio, right click on the xcAdmin database and select Properties
2. Click on Options and set the Recovery Model to Simple, hit OK to save
3. Right click on the xcAdmin database again and shrink the database or the log file

You can also shrink the log file by running the following SQL Query against the xcAdmin database:

Use xcAdmin

DBCC SHRINKFILE(xcAdmin_log, 10)

BACKUP LOG xcAdmin WITH TRUNCATE ONLY

DBCC SHRINKFILE(xcAdmin_log, 10)

Link to KB article from Cyrus' original post is: metalogix.force.com/.../Transaction-log-of-xcAdmin-database-consumes-disk-space

Good luck and please let us know how it goes, thanks!

-Siam