08-15-2011 10:54 AM
this was just thrown into my lap. our main server had some issues and with it the main Database for ACT! 10 is toast. We made back ups, but was hosted on the same computer.
We have several users who have remote databases, and we can still log into those on the remote machines outside of our network.
is is possible to recreate our main database using these remote databases?
08-15-2011 01:27 PM
Welcome to the Sage ACT! Online Community!
Using a backup (File > Backup > Database) of a remote database you will be able to create a new 'main/publisher' database, but it will not contain the sync information like the original/lost database. Once you have created a new database from a backup (File > Restore > Database > Restore As) of a remote, you will need to create new remotes for the workstations.
To prepare for creating the new Publisher and remotes - the best practice is to backup all available remotes and restore them on the server. Then choose one to be the new Publisher > open the other remotes and perform a Lookup > Contact Activity (with a date just before the last successful sync) > and Export (File > Export > Current Lookup) the changes to the new Publisher. Then when the new remotes are created, the data from all of the remotes will be contained within the new remote(s).