Question: My database ADF file has reached 10 gigabyte in size, what should I do?
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: 2005 and later
Environment:
Engine: Microsoft SQL Server Express
Answer:
Microsoft SQL Server Express is limited to 10 gigabyte databases therefore your database may be inaccessible. If you are unable to log-on to the database, the only solution to access your it is to upgrade to Act! Premium and install Microsoft SQL Server Standard.
You can visit the Microsoft web site for more information on SQL Server Standard:
http://www.microsoft.com
If you are able to log-on to your database you can try following:
After completing the above steps you will have one database again that contains all your data, you will also have an archive of your complete database in the two backups, you can restore these by following the steps here:
How to back up and restore an Act! database
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: 2005 and later
Environment:
Engine: Microsoft SQL Server Express
Answer:
Microsoft SQL Server Express is limited to 10 gigabyte databases therefore your database may be inaccessible. If you are unable to log-on to the database, the only solution to access your it is to upgrade to Act! Premium and install Microsoft SQL Server Standard.
You can visit the Microsoft web site for more information on SQL Server Standard:
http://www.microsoft.com
If you are able to log-on to your database you can try following:
- Create an Empty Copy of your database
How to Create an Empty/Blank Copy of Your ACT! Database
- Once the empty copy has been created log in to your main database and export data to the empty copy to reduce the database size
How do I export data from one Act! database to another
- Once the export has been completed backup both databases to create an archive of all your data:
How to back up and restore an Act! database
- Once the two backups have completed remove old data from both of the databases:
How do I remove old data from my Act! Database?
Answer ID 14168
- Once you have removed old data you can merge the two databases in to one:
How To Import Contact Data From an Existing ACT! Database Into Another ACT! Database
Answer ID 22042
After completing the above steps you will have one database again that contains all your data, you will also have an archive of your complete database in the two backups, you can restore these by following the steps here:
How to back up and restore an Act! database