Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35

    Question Unanswered: Active Log Files Deleted

    Wondering if there is a way to recover a database if all active log files get deleted by mistake.

    Of course assuming that some of the transactions will be lost once recovered.

    I am talking of a situation in which there is no backup of the database present.

    Think of it as a Crash Recovery.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No there is no way. DB2 need the logs to do crash recovery. Who ever allowed the database to go without a backup and allowed someone access to delete the active logs should be fired.

    Andy

Posting Permissions

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