Community
Showing results for 
Search instead for 
Do you mean 
Reply

restoring backup database to a new computer

Accepted Solution Solved
New Member
Posts: 2
Country: USA
Accepted Solution

restoring backup database to a new computer

Hi all,

 

I just migrated from Goldmine to ACT2008 (10) standard.  The migrate admin tool brought over all of my emails from Goldmine. They show up as email attachments in on the "history" tab for each contact.  I am now trying to move the ACT database over to my new computer (Vista32) on which I have installed ACT2008.  I backed up the database using the backup utility and ended up with a 614MB zip file.  I put this on my new computer and then went through the "restore as" procedure.  The procedure starts, then stalls at the point where the window says it is restoring attachments.  I need to end the process and I end up with a few database files in the ACT directory (about 1.2MB in the attachments folder), but nothing else, and no database that I can open.  Any suggestions or help would be appreciated. I am totally new to ACT, so I hope I am just making a simple mistake. Thanks.


Accepted Solutions
Solution
Accepted by topic author rfiedler
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 118
Country: india

Re: restoring backup database to a new computer

goto the machine where your database is

close act

goto start | run | services.msc

stop sql server (act7) service

goto the location where your database files are

copy the < database name>.adf, alf & database files folder and move it to your vista machine

move these files to location on c:\

open act

goto file | open database | select file type act database .adf

should be able to open the database with all attachments

 

View solution in original post


All Replies
Solution
Accepted by topic author rfiedler
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 118
Country: india

Re: restoring backup database to a new computer

goto the machine where your database is

close act

goto start | run | services.msc

stop sql server (act7) service

goto the location where your database files are

copy the < database name>.adf, alf & database files folder and move it to your vista machine

move these files to location on c:\

open act

goto file | open database | select file type act database .adf

should be able to open the database with all attachments

 

New Member
Posts: 2
Country: USA

Re: restoring backup database to a new computer

Absolutely, totally worked.  Wow. Thank you. Saved me lots of time and frustration.  It is very nice to bid a final farewell to Goldmine. Thanks again.
New Member
Posts: 1
Country: USA

Re: restoring backup database to a new computer

Hi.  Maybe you can help me.

 

I have in one pc ACT 2006 and tomorrow I'm going to install ACT Pro2011 in a new pc.  I have to transfer the database from the old program to the new pc/ACT2011.

 

Will I have problems doing this or will it be a straight forwar process...backup data to flashdrive ans import it to the new ACT?

 

Tks

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: restoring backup database to a new computer

Hello Proparents,

Welcome to the ACT! Online Community!

 

Since you are moving to a new computer,  you will create a backup of your database using Act! 2006 (File > Backup > Database), then copy the backup file (*.zip) to the new computer and restore the backup using Act! 2011 (File > Restore > Database > Restore As).

 

Here is an article with instructions for running the backup and restore procedures: KB Article 19211

 

 

Greg Martin
Sage
New Member
Posts: 1
Country: USA

Re: restoring backup database to a new computer

I tried this and it gives me SQL errors

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: restoring backup database to a new computer

Hello ComfortSuites,
Welcome to the Sage ACT! Online Community!

For the Community members to better help with your issue, can you provide additional information about what you are attempting when the error occurs and the error itself.

Also include the version of Sage ACT! and the operating system(s) involved.
Greg Martin
Sage
New Member
Posts: 2
Country: USA

Re: restoring backup database to a new computer

[ Edited ]

I have ACT 2013 PRO on a windows 8 machine.

 

The machine was attacked and locked up by Russian FBI virus.  I can read files in disks but cannot run that computer.

 

I cannot restore or move to a new computer, something about improper install of MSC SQL.

 

How can I do it?  

 

Thanks.