Load ACT backup files into SQL-Server

I have a client whose ACT contacts table was scrambled due to a rogue PDA synchronization.  I have backup files produced by AutoAdmin III from prior to, and after, the corruption.  I need to find a way to load them into SQL-Server to identify the affected rows.  The files are named like SQL-Server files (xxx_master, xxx_model, dbname) with a .bak extension.  SQL-Server states they are "not in a primary database format" if you try to attach them.

Thanks in advance.
LVL 13
AielloJAsked:
Who is Participating?
 
AielloJConnect With a Mentor Author Commented:
Must resort to a manual process.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
You should be able to use File | Restore in ACT!

For PDA, I find issues with a lot of the link solutions. The best option (if using Blackberry or Windows Mobile) is Handheld Contact. You can download a trial to test from www.GLComputing.com.au/HHC
0
 
AielloJAuthor Commented:
Would we be able to restore only the Contacts table?

FYI:  The corruption was caused by users not properly signing out from the Remote Access Server (RAS).  "Orphaned" RAS sessions running when the user synchronized her PDA caused the Contacts table data to be scrambled.  My company (a vendor to the client) is now categorized as an accounting tax client with some other name listed as the owner.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
No, you can't just restore one table.

What PDA do they use?
What do they use to sync it to ACT!?

Do you have a backup before the damage? If so, you might look at restoring that.
0
 
AielloJAuthor Commented:
Unfortunately we have to correct/restore the Contacts table only as they continued to input appointments, etc for the contacts that were unaffected.  I have backups created by AutoAdmin III prior and post corruption.  The goal is to to load the Contacts into SQL-Server for analysis if possible.

This client has over 6K contacts and extensions to the number of columns (~243 columns).  I don't rememer the PDA brand, but they are using CompanionLink for sync.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
If you take out the contacts, you won't easily be able to merge them back in.

If you restore a good copy, you can try and import the damaged one - telling it to leave the contacts intact and merge new activities and histories.

You'll need to have some fields the are fairly unique and not damaged to match with
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Which manual process?

If you think you can do it in Excel, restore the database, use itImport to auto number all the records and export them to Excel from the Contact List (including the auto number field)

Fix them in Excel, then merge them back with itImport using the Auto number field as the match field

You can get itImport from http://www.glcomputing.com.au/main/57/1

This is the easiest way to work on the contact table and not lose all the sub-table links.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.