Trans log Recovery

  • A full database backup is taken every 24 hours, at 7:01PM. Differential backups are taken every 6 hours starting at 12:01 AM and transactional backups are taken every hour, starting at 12:31 AM on the FACTORYSALES database. At 6:38 PM, an end user with escallated privelages TRUNCATES data in the CUSTOMER table accidentally. All data in the CUSTOMER table must be recovered prior to the errant TRUNCATE. What steps should you follow to recover the data?

  • Is this a homework or test question?

    Perhaps you can post what you think should happen and we can help guide you.

  • Steve Jones - Editor (10/31/2007)


    Is this a homework or test question?

    Perhaps you can post what you think should happen and we can help guide you.

    +1

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply