Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Size doubled after import

Tuned Listener
Posts: 30
Country: USA

Database Size doubled after import

We´ve just exported activities of an amount of 2000 contacts from a remote database to the publisher database (because the sync won´t work anymore with that remote). After that, the Main database doubled in databse file size! Any suggestions ?
Nickel Elite Contributor
Posts: 595
Country: USA

Re: Database Size doubled after import

My first question is did you make a backup of the publisher database before you did the import? If so, I would restore the backup.
 
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database Size doubled after import

Because it's a sync database, it will keep transaction logs which might account for the size
 
As long as no other remotes, turn off sync and run Database Maintenance