Restoring backup database to a new computer [ Edited ]

[wongper]

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

[brice · Accepted solution]

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

[brice · Accepted solution]

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

[wongper]

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