Results 1 to 2 of 2

Thread: restore problem

  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: restore problem

    trying to restore a full offline back of our prod database into a new database on a different system. both instances are DB2 V9.5 on windows

    Code:
    RESTORE DATABASE PRODDM  FROM "I:\ProdDMBackup\" TO "G:" INTO DUTDM WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING
    SQL1005N The database alias "DUTDM" already exists in either the local
    database directory or system database directory.

    then i issue the following commands
    uncatalog database dutdm;
    deactivate DATABASE DUTDM;
    DROP DATABASE DUTDM;

    and they all come up with the error
    "SQL1013N The database alias name or database name "DUTDM" could not be found. SQLSTATE=42705"


    help!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look at the directory tree of G:. You may have an uncataloged database structure there.

    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
  •