Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT 10 Lost main Database and server, trying to recover with remote databases???

New Member
Posts: 1
Country: USA

ACT 10 Lost main Database and server, trying to recover with remote databases???

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?

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: ACT 10 Lost main Database and server, trying to recover with remote databases???

Hello Mletendre,

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).

Greg Martin
Sage