Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lost Database

Accepted Solution Solved
Astute Commentator
Posts: 12
Country: United Kingdom
Accepted Solution

Lost Database

My old laptop has failed but I have managed to copy the folders containing ACT databases on to new hard drive.

 

I am running ACT! by Sage 2008 (10.0) Version 10.0.2.191 and have installed this on new laptop and registered on line.

 

Demo database opens ok but any attempt to open databases I have transferred on to new drive are flagged with the following message "Cannot find database supplemental files folder in this location."

 

Any suggestions would be greatly appreciated

 

regards

bryan rulton

 

 


Accepted Solutions
Solution
Accepted by topic author brulton
‎09-25-2015 03:20 AM
Silver Contributor
Posts: 1,813
Country: USA

Re: Lost Database

[ Edited ]

When you are forced to move ACT from one machine to another and do not have a recent backup, you can just move the files over.

STEP 1: If the old machine is still operating, you will need to stop sql before you move the files. 

IF ACT IS STILL INSTALLED ON THIS MACHINE AND YOU SKIP THESE STEPS YOU WILL NOT GET ALL OF YOUR DATABASE

This can be done one of two ways.

1)     From the old machine, start, run, services.msc find the service SQLServer (ACT7) - you can right click on this service and choose Stop.

2)     The other way is to start ACTDIAG, Start, Run, ACTDIAG. When the ACTDIAG program upens, click on the database tab/menu and find your database. Then right click and choose detach.

STEP 2: If the old machine is no longer running or once SQL has been stopped, you can copy the files.  When you browse to the database files, you will find 4 things for a database called MYDatabase.  MyDatabase.pad, MyDatabase.adf, MyDatabase.alf and MYDatabase-database files.  and.  YOU DO NOT NEED THE .PAD FILE. IT IS JUST A POINTER..  Copy the .alf, the .adf and the database files folder to the new machine.

STEP 3: On the new machine, Open ACT, choose File, Open and bowse to the location where you copied the .alf, the .adf and the database files folder.  YOU NOW NEED TO SELECT .ADF INSTEAD OF .PAD FROM THE FILE OPEN DIALOG BOX.

ACT will now reattach the database to the SQL instance in your new machine

 

http://blog.acttrainer.com/moving-an-act-database-to-another-machine-when-there-is-no-backup/ 

 

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

View solution in original post


All Replies
Solution
Accepted by topic author brulton
‎09-25-2015 03:20 AM
Silver Contributor
Posts: 1,813
Country: USA

Re: Lost Database

[ Edited ]

When you are forced to move ACT from one machine to another and do not have a recent backup, you can just move the files over.

STEP 1: If the old machine is still operating, you will need to stop sql before you move the files. 

IF ACT IS STILL INSTALLED ON THIS MACHINE AND YOU SKIP THESE STEPS YOU WILL NOT GET ALL OF YOUR DATABASE

This can be done one of two ways.

1)     From the old machine, start, run, services.msc find the service SQLServer (ACT7) - you can right click on this service and choose Stop.

2)     The other way is to start ACTDIAG, Start, Run, ACTDIAG. When the ACTDIAG program upens, click on the database tab/menu and find your database. Then right click and choose detach.

STEP 2: If the old machine is no longer running or once SQL has been stopped, you can copy the files.  When you browse to the database files, you will find 4 things for a database called MYDatabase.  MyDatabase.pad, MyDatabase.adf, MyDatabase.alf and MYDatabase-database files.  and.  YOU DO NOT NEED THE .PAD FILE. IT IS JUST A POINTER..  Copy the .alf, the .adf and the database files folder to the new machine.

STEP 3: On the new machine, Open ACT, choose File, Open and bowse to the location where you copied the .alf, the .adf and the database files folder.  YOU NOW NEED TO SELECT .ADF INSTEAD OF .PAD FROM THE FILE OPEN DIALOG BOX.

ACT will now reattach the database to the SQL instance in your new machine

 

http://blog.acttrainer.com/moving-an-act-database-to-another-machine-when-there-is-no-backup/ 

 

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider