10-12-2012 11:51 AM
We upgraded from ACT 2011 to 2012 almost a year ago and in the past 5,6 months we were confused about our daily backup file size which kept growing by 20mb per day, sometimes 40mb. so from a 1.5gb zip file 6 months ago we have ended up with a 4gb zip file. Something we noticed that doesn't make sense is that the ALF file is 35GB !!
Our ADF file is 1.7GB.
We tried to recreate the ALF file, so we ditached the database, renamed the alf to alf.old and tried to attach the database (from actdiag page) and it didn't work (it was giving an error message). To be able to open the database again, we had to rename the ALF back to its original name and do a restore from the last backup file and it got attached and openned but still the ALF file remains 35GB.
I am assuming that the ALF file being a log file btw SQL and ACT can't be 20 times of the database size and if this file plays a role in the backup(zip) file then we need to some how reduce its size or get rid of it and make a new one.
I really appreciate any advice here.
10-12-2012 12:46 PM
10-12-2012 12:49 PM
10-12-2012 01:55 PM
Thanks for the reply.
Under databases it lists the DB as:
size: 1703 version:220.127.116.11 sync:No options: full recovery - auto update and create statistics
*other smaller and older DBs options show simple recovery though.
We have never used the sync option, remote users access our VPN and then use IE broswer to log in to ACT.
I can try: Actdiag – check, repair, reindex tonight when users are not connected.
You said: "You might stop the SQL file and copy the ADF/ALF to another folder and then restart SQL (just in case)" is this a second solution or you mean doing this before the reindex solution?
Also do you mean Stopping SQL service?
10-12-2012 02:49 PM
10-12-2012 03:34 PM
Thanks... I will do the repair, reindex to see if it reduces 35gb file. saving as would be an easy way to go too, but the web settings are not.
Thanks again. I post the result here.
10-12-2012 04:52 PM
Ive seen this happen a few times before and we ended up having to do a file save copy as. I can''t remember 100% but I think on one of them we had to save as an empty copy, then setup the Users in the new database, and import the other contacts.
10-12-2012 04:53 PM
10-15-2012 11:21 AM
10-16-2012 12:30 AM