Community
Showing results for 
Search instead for 
Do you mean 
Reply

Data suddenly lost - how do I recover?

New Member
Posts: 6
Country: USA

Data suddenly lost - how do I recover?

Using Act Pro 2013 -- I was deleting a single contact and Act froze. Had to terminate program after waiting 10 minutes and when I re-opened Act, I lost 7000 contacts. Is there a way to recover other than from a back-up? I just learned my online backup service (Mozy) does not create a zip file. Thanks!

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Data suddenly lost - how do I recover?

I have recovered an ACT! database from a Mozy backup so it can be done if you are backing up the database on Mozy.  If your ACT! database is in your My Documents folder (it usually is) and you are backing up your My Documents folder on Mozy (you usually are) then you can probably get it back.  Recovering it can be a little bit tricky but it isn't too bad.  Basically you will need to shut down your SQL service and then restore the database.  Contact me offline if you want me do do it for you.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
New Member
Posts: 6
Country: USA

Re: Data suddenly lost - how do I recover?

Thanks for the reply Stan. I just checked my Mozy status and regrettably, it isn't capturing the back-up, a problem I have just fixed going forward. Not sure why ACT froze then lost data -- second time in a month. I'd like to resolve the root cause so if you have suggestions, I'm all ears. Thanks.

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Data suddenly lost - how do I recover?

I suspect that you chose to delete the lookup rather than the current contact. If your lookup was all contact it was trying to delete the entire database. 

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Bronze Super Contributor
Posts: 1,544
Country: United_Kingdom

Re: Data suddenly lost - how do I recover?

Again another case of how vital it is to use an Act! consultant.  The small cost is worth every penny when your business is in the database.

 

2 basic points we make:

 

1. Schedule a regular backup (and test it)

2. Read all messages when they appear before proceeding.  When deleting there are at least 2 warnings!

 

It's about time that SP passed on the importance of implementing Act! (and any application) correctly.  Is your business worth the risk?? I wish we consultants could help such sorry situations such as this.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
New Member
Posts: 6
Country: USA

Re: Data suddenly lost - how do I recover?

I suppose that is a possibility. Strangely, it deleted all records from A to S and left T and beyond.

Bronze Super Contributor
Posts: 1,544
Country: United_Kingdom

Re: Data suddenly lost - how do I recover?

In terminating Act! you probably stopped it deleting beyond S.

David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Data suddenly lost - how do I recover?

I agree with David.  I suspect that you selected delete lookup. That's most likely what happened.  I've never seen ACT! delete 7000 contacts when the end user didn't tell it to and I've been working with ACT! for 23 years now.  It is theoretically possible if the hard drive failed in a location that contained the ACT! database but I've never seen it happen.  Unfortunately there isn't any way to recover except to restore from a backup.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
New Member
Posts: 6
Country: USA

Re: Data suddenly lost - how do I recover?

Forgive my ignorance, but just so I don't repeat the problem, can you explain deleting lookups? When I look at the lookup pull-down, there isn't a delete function. Thanks for clarifying.

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Data suddenly lost - how do I recover?

To delete contacts you usually choose Contacts from the menu and then Delete Contacts.  Then you have three buttons and you almost never want to click the middle one.  :-)

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!