Results 1 to 5 of 5

Thread: Drop & Restore

  1. #1
    Join Date
    Jul 2011
    Posts
    5

    Unanswered: Drop & Restore

    I am using DB2 v9.1 windows, I want drop database <a> and do a restore database <a> from a backup dataset for database <b>.

    I get the following error

    SQL30061N The database alias or database name "<a> " was not
    found at the remote node.

    The only command I am issuing is a RESTORE
    Last edited by IsaarAhmed; 07-08-11 at 06:15.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Are you issuing any commands that cause this error?


    z
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    Please share the command you are using

  4. #4
    Join Date
    Jul 2011
    Posts
    5
    What I want to do is backup database <b> on server B and restore as database <a> on server A, database <a> already exists. what I did is

    1. Backup database <b> on server B and copy the backup to server A.

    2. DROP database <a>

    3. restore

    RESTORE DATABASE database <b>
    TAKEN AT timestamp
    ON D:\xxxx1,D:\xxxx2,D:\xxxx3
    DBPATH ON D:\
    INTO database <a>
    NEWLOGPATH log path
    WITHOUT ROLLING FORWARD
    WITHOUT PROMPTING;

    I get the error above however if I change the INTO line to
    'INTO database <c>' a databse name that does not exists on server A it works fine....

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Did step #2 (drop db) complete successfully or generated some error/warning?


    What's the output from:

    db2 list db directory
    db2 list db directory on d:

Posting Permissions

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