Community
Showing results for 
Search instead for 
Do you mean 
Reply

Moving the database without a backup

New Member
Posts: 4
Country: USA

Moving the database without a backup

Hello all,

 

I have an environment with one server and two or three clients connecting to the database via Windows (It was the web version of 2011 Premium, but no one used web).  Recently the server went down and will not be able to get it going again.  I have all the data as the disks were fine, but I did not have an up to date backup of the database.

 

My plan was to turn on of the workstations into the host for the database and attach the other two clients to it, but I'm at a loss as to how to move it.  Am I able to use the Act client as the new server or is there some other prep I have to accomplish?

 

Thanks

AI

Platinum Elite Contributor
Posts: 14,384
Country: Australia
Silver Contributor
Posts: 1,813
Country: USA

Re: Moving the database without a backup

Here is another one.

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

New Member
Posts: 4
Country: USA

Re: Moving the database without a backup

Thanks, I think that second one will do the trick.

 

Are ACT client and server installs the same?  I downloaded the intaller and tried running it on one of the clients, but it only gave me the option to uninstall Act.  I'm hoping I just have to have SQL installed with the Act client in order to turn it into the new server.

Silver Contributor
Posts: 1,813
Country: USA

Re: Moving the database without a backup

Yes, the steps to install on a workstation and a server are the same.

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

New Member
Posts: 4
Country: USA

Thanks for the help, I was able to move those two databas...

Thanks for the help, I was able to move those two database files and Act attached them to SQL.  All the actual data appears to be there, but none of the custom views or fields moved with it.  Is there any way to retrieve these from the server as well?  There were some other directories in the same location as the database files, do I need to move these as well?

 

Thansk

~AI

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Thanks for the help, I was able to move those two databas...

The Supplemental files subfolders ... one of them called "Layouts" - but you should move all the subfolders over
New Member
Posts: 4
Country: USA

Re: Moving the database without a backup

That did the trick, thanks!

 

~AI