Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: Online backup restore with no log files

    DB2 UDB V7 FP9 on Windows

    I have a online backup of one of the test database but no log files corresponding to that. Can I still restore this database and skip rollforward completely but still have operational database in hand?

    dollar

  2. #2
    Join Date
    Dec 2002
    Location
    cincinnati
    Posts
    18

    Re: Online backup restore with no log files

    As far as I know, in db2 udb version 7, without having logs ( either archive or current logs) we will not be able to restore from online backup.
    Thanks
    Jagadish


    Originally posted by dollar489
    DB2 UDB V7 FP9 on Windows

    I have a online backup of one of the test database but no log files corresponding to that. Can I still restore this database and skip rollforward completely but still have operational database in hand?

    dollar
    jagadish dara

  3. #3
    Join Date
    Mar 2003
    Posts
    343

    Unhappy

    No you cannot. The database must be rolled forward to the minimum point in time.

Posting Permissions

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