Restoring Databases

[TekWitch]

Help -

Someone decided to clean house and deleted a bunch of documents from one of my databases (needless to say they don't have that right any more) - but how do I safely restore the missing documents from multiple back ups w/o losing the newer information or messing up my 30 plus salesman's replicas on thier notebooks (some of these guys only replicate once a month, others do daily)

Everytime I try to restore the files and then copy the documents in question I get "Document has been deleted" errors and if someone does replicate they end up woth four local databases - one for each file I had to restore from tape.

I should probably mention my Dom server is AS400. Any suggestions may just save my job.

Thanks in Advance

 

[Packet7]

Hello,
I have no exp with an AS400, but I have done this in the past:
1. Create a Replica of the existing DB on your PC (disable replication)
2. Restore the DB from backup to an alternate location (mail\Restore)
3. Utilize the "All Documents view" on each DB to determine what is missing (maybe a certain date?)
4. Copy and paste from the old to the new (on your PC)
5. Delete the DB in the server
6. Create a replica from your PC up to the server
7. Test

Just an idea...

Rgds,

John Judge

 

[TekWitch]

Thanks for the suggestion but I tried all that - the only fix I found was copying the database to a W2K server (my back up Dom server - and like magic - everything is working fine.

I appreciate your assistance.

Tori