Community
Showing results for 
Search instead for 
Do you mean 
Reply

How to restore a remote database?

New Member
Posts: 22
Country:

How to restore a remote database?

I just had a virus wipe one of my sales guys computers.
We lost everything that wasnt on a network drive..

I am trying to restore his remote database, but i am unsure where to begin.
Im pretty sure the standard procedure is to run a restore from within ACT and point it to the .pad file?
However, i dont think his pad file was saved on the server. (apparently the old IT guy did not do that?)

What do i need to do to restore his remote Database?

Any input is appreciated!

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: How to restore a remote database?

Hello JZeFF,
I'm sorry to hear this happened. Normally, you can just open ACT!, go to File > Restore > Database, choose the Restore option, browse to the backup (.zip) file, and restore it. If successful, the remote database should be restored and be able to sync.

Whether this succeeds or not depends on state of the machine after the virus recovery. Please post back here if you run into any error messages or issues when restoring the backup or attempting to sync the restored database.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Silver Contributor
Posts: 1,813
Country: USA

Re: How to restore a remote database?

If you had to reimage. make sure you create a new database from teh server instead of trying to unpack and restore the old one.

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: 22
Country:

Thanks for the response! I had to reinstall windows on t...

Thanks for the response!

I had to reinstall windows on thr machine, so it should be all set,
Do i have to create a backup file within ACT on the server before i i can restore the remote DB on the laptop?

Must i login to ACT on the server using the credenials of the user who lost his DB before i run the backup?

New Member
Posts: 22
Country:

Re: How to restore a remote database?

"If you had to reimage. make sure you create a new database from teh server instead of trying to unpack and restore the old one."

Can you explain to me how i would create a database from the server?

Thanks

Silver Contributor
Posts: 1,813
Country: USA

Re: How to restore a remote database?

assuming it was setup and working before it should be fairly easy.     Here is an article that goes over the steps.

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/14116/~/how-to-create-a-remote-database

 

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: 22
Country:

Re: How to restore a remote database?

So i tried to go ahead and follow the directions in that article.

It fails.  The status is "An IO exception occured while copying the data from the item... (there is more to the message but it wont let me view it.)

Any clue what could be causing it to fail?


New Member
Posts: 22
Country:

Re: How to restore a remote database?

[ Edited ]

Bump.

Would really like to try ang get this error message figured out.
I have a feeling it is being caused by low space on the C drive.

The server that is currently hosting ACT is pretty old, the C drive has a maximum capacity of 12gb.
Is there any way i can get around this without cloning the HD to a larger one?

Silver Contributor
Posts: 1,813
Country: USA

Re: How to restore a remote database?

YOu could restore it to another machine and move it.  but it's gets a little technical.

1) first restore, on another machine.

2) detatch from SQL (via actdiag) and move to the new machine.

3) reattach to sql (also via ACT diag), you will also need to point the supplemental files to the new machine

 

then use the article 

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/19817/~/how-to-retain-synchronization-when-...

 

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