asked on

Deleted Record in Goldmine

Hi,

A user has somehow deleted a record from Goldmine, is there a simple way of retrieving this record from either within Goldmine or at the SQL level?

Thanks

Steven Graff

If you're using the SQL version of GoldMine, no, there's no easy way to retrieve it. You'd have to restore your database from a backup to a "dummy" db within your SQL server, then selectively copy the affected record(s) into your production GoldMine, using back-end tools.

There's another way of doing this as well:

1. Restore your db to SQL as a "dummy" db
2. Connect to it from within GoldMine
3. Create a new record in that db.
4. Do a merge/purge (either tagged or visible) between the two records (the new one, and the one you want to restore)
a. You want the "surviving" record to be the new one you just created
5. Do a "copy/move records" operation (from the Synch menu) to move that record into your production GoldMine db.

daiwhyte

ASKER

Ok, so I get last nights db backup and restore in using SQL Server Management Studio? Ive not done that before and Im concerned I could restore over the top of the live db. Any pointers on this one Steven?

Then connect using goldmine? I take it I go into File, Open Database. In this screen do I have to attach to the newly restored DB?

Any advice/pointers you can give would be really appreciated.

ASKER CERTIFIED SOLUTION

Steven Graff

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

daiwhyte

ASKER

Thank you Steven, Ive managed to restore the db to a test server and copy the data to the live db.