Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    123

    Unanswered: Restore command prompt

    Hi,

    If I give the db2 restore command, then I get the following message...

    SQL2539W Warning! Restoring to an existing database that is the same as the backup image database. The database files will be deleted.
    Do you want to continue ? (y/n)

    We are trying to put this command as a part of an automatic script that runs early morning. Can you think of anyway we can avoid any manual intervention to press 'y' to continue with the restore? thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Are you using the "WITHOUT PROMPTING" clause?

    Andy

  3. #3
    Join Date
    Dec 2002
    Posts
    123
    Thanks for the reply.. I also found the REPLACE EXISTING option...that should also work.

Posting Permissions

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