Community
Showing results for 
Search instead for 
Do you mean 
Reply

Restoring backup database to a new computer

Accepted Solution Solved
Copper Contributor
Posts: 25
Country: Canada
Accepted Solution

Restoring backup database to a new computer

[ Edited ]

Hi, using two machines but only one master for daily use and update, the other is for read only. If I don't use the sync option (issues with internet and networking), can I backup from the master and restore to the read only machine without having to create a new database every time? The current restore options are:

Restore - only to restore on same machine and same location

Restore as - only allow to restore to a new database and new location (no option to overwrite)

Unpack - only works for creating a remote database

 

Any suggestions will be very much appreciated

 

Thanks

Perry


Accepted Solutions
Highlighted
Solution
Accepted by topic author wongper
‎07-11-2019 09:42 AM
Copper Super Contributor
Posts: 106
Country: United States

Re: Restoring backup database to a new computer

You can only do a normal RESTORE on the same computer that created the backup.  If you want to move the file to another machine you MUST use the RESTORE AS.  On the second machine when you want to create the next copy of the database open Act! and with the database open do a TOOLS > DATABASE MAINTENANCE > DELETE DATABASE and then restore the new back up as a RESTORE AS on the 2nd machine.

 

-Bud

 

Bud Rice

Executive Business Systems

Pleasanton, CA 94588

 

 

View solution in original post


All Replies
Highlighted
Solution
Accepted by topic author wongper
‎07-11-2019 09:42 AM
Copper Super Contributor
Posts: 106
Country: United States

Re: Restoring backup database to a new computer

You can only do a normal RESTORE on the same computer that created the backup.  If you want to move the file to another machine you MUST use the RESTORE AS.  On the second machine when you want to create the next copy of the database open Act! and with the database open do a TOOLS > DATABASE MAINTENANCE > DELETE DATABASE and then restore the new back up as a RESTORE AS on the 2nd machine.

 

-Bud

 

Bud Rice

Executive Business Systems

Pleasanton, CA 94588

 

 

Copper Contributor
Posts: 25
Country: Canada

Re: Restoring backup database to a new computer

[ Edited ]

Thanks Bud for the input, I was hoping there is an overwrite option. Cheers