Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database detailed report

Accepted Solution Solved
Copper Contributor
Posts: 93
Country: Switzerland
Accepted Solution

Database detailed report

Is there a way to have a detailed database report (per user, how much space used for attachments ... )?

We are running ACT for three users and the DB size is increasing too fast, we'd like to know where this problem's coming from


Accepted Solutions
Solution
Accepted by topic author albergante
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Database detailed report

I agree with Mike's direction - determine which particular file or folder is out of proportion.

I would also suggest looking at the Backup folder (within the Database Files folder), are you saving database backups into that folder? If yes, I recommend changing to a different folder (outside of the Database Files folder) and manually moving the existing backups to that new location.
Greg Martin
Sage

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database detailed report

The Database is the ADF ... which doesn't include the attachments.

What's actually increasing in size?
Copper Contributor
Posts: 93
Country: Switzerland

Re: Database detailed report

My apologies for the lack of clarity.

 

What's actually increasing in size are remote databases.

Remote databases created on the 'host' installation for remote clients were a couple of hundreds of MBs last month.

Now they're ten times as big, and I'd love to know where all this disk space is going.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database detailed report

1. Is the the ADF, ALF or the attachments folder?

2. What version/build of ACT! from help | about?
Copper Contributor
Posts: 93
Country: Switzerland

Re: Database detailed report

1. The RDB file, so I guess all the three you prevously mentioned

2. Sage ACT! Pro 2012 Version 14.1.108.0

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database detailed report

1. Is there much more data on the server or only the RDBs?
2. Is there a Hotfix in the version?
Copper Contributor
Posts: 93
Country: Switzerland

Re: Database detailed report

1. The only symptom is the large RDB, haven't checked anything else

2. No hotfixes

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database detailed report

1. You need to work out where the extra data is ...

2. Probably not related, but you might want to look at adding the latest hotfix as per this ACT! Knowledge Base article -
http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28810
Copper Contributor
Posts: 93
Country: Switzerland

Re: Database detailed report

1. Exactly my point in the original question

>> Is there a way to have a detailed database report (per user, how much space used for attachments ... )?

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database detailed report