New call-to-action
Results 1 to 2 of 2

Thread: How to examine 'deleted records'?

  1. #1
    Real Name
    Robin Henagulph
    Join Date
    Jul 2015

    Default How to examine 'deleted records'?

    Having accidentally deleted an entire DB of 54,000 records we restored with a Backblaze backup. There were many legitimate deletions made before the restoration and no 'packing'. How can I examine the deleted records without restoring them?

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Delavan, Wisconsin

    Default Re: How to examine 'deleted records'?

    I'm a bit confused about the methods you used to delete and the timing of the backup and restore.

    Deletes rather than a table.zap aka truncate?

    So from the help files

    Undeleting Records

    To undelete records:

    Right click on the table in the Table/Set tab of the Control Panel.

    Select Utilities > Undelete Records....

    Optionally check Mark records that are undeleted. This gives you the opportunity to easily identify the records that you have undeleted.

    Optionally select Range of records and enter a Start Record # and End Record #.

    Click OK to undelete the selected records. [Picture]
    So you can determine what you have undeleted if you choose the option to mark the undeleted records.
    Of course that means you shouldn't have some of the records marked otherwise how could you tell which ones were undeleted?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Records Deleted
    By omagarc in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 07-01-2010, 01:11 AM
  2. Replies: 4
    Last Post: 05-13-2008, 05:42 PM
  3. Deleted records A5 vs A4
    By Brad Gaylord in forum Alpha Five Version 5
    Replies: 10
    Last Post: 01-26-2006, 11:06 PM
  4. How to see deleted records?
    By Stephen Osborne in forum Alpha Five Version 4
    Replies: 2
    Last Post: 03-30-2001, 07:44 PM
  5. Deleted Records
    By richardurban in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-22-2000, 03:53 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts