Results 1 to 14 of 14
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: Redirected Restore Error

    I am having problems with my redirected restore. I am restoring a DB using a backup from another DB.
    The error that I am getting is:
    Code:
    SQL2542N  No match for a database image file was found based on the source
    database alias "NAMDWH" and timestamp "" provided.
    and the code is:
    Code:
    restore database NAMDWH user DB2admin using ******** from F:\20060301 to G: into NAMDWH redirect;
    Has anyone seen this? Does any one have any thoughts on how to get around this?
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Try F:\ instead of F:\20060301 .. If you have more than one backup in f:\, then include the TAKEN AT Clause in the RESTORE Command.

    BTW, is F:\ a local drive ?

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

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    restore

    If you backup a db to F:\backup there will be a directory f:\backup\instance\dbname.0\node...
    the ideal is to create the same directory structure on target
    note : create directories in command window, because explorer will do casemapping....
    restore from f:\backup taken at xxxx
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Mar 2005
    Posts
    9
    Don't forget to reference the database that was backed up not the database you might be restoring into.

  5. #5
    Join Date
    Mar 2005
    Posts
    9
    Don't forget to reference the database that was backed up not the database you might be restoring into.

  6. #6
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Quote Originally Posted by sathyaram_s
    Try F:\ instead of F:\20060301 .. If you have more than one backup in f:\, then include the TAKEN AT Clause in the RESTORE Command.

    BTW, is F:\ a local drive ?

    Cheers
    Sathyaram
    Yes F us a local drive. Unfortunatly I got the same error
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What was the backup command that you used?

  8. #8
    Join Date
    Sep 2003
    Posts
    237
    db2ckbkup -h filename will give you the image name expected by the restore utility. 'filename' in your case is 200....... Use that name instead of F:\...
    mota

  9. #9
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Quote Originally Posted by dbamota
    db2ckbkup -h filename will give you the image name expected by the restore utility. 'filename' in your case is 200....... Use that name instead of F:\...

    Should I run this on the server were the backup was taken or on the server that I am trying to restore it on?
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  10. #10
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Wherever you file is ...

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

  11. #11
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Quote Originally Posted by sathyaram_s
    Wherever you file is ...

    Sathyaram
    I have done a search for the command db2ckbkup. That command is not on my server. I get the following error. Is this a UNIX only command?

    Code:
    D:\Program Files\IBM\SQLLIB>db2ckbkup -h I:\NamBackups\FULL\NAMDWH.0\DB2\NODE000
    0\CATN0000\20060301\081853.001
    'db2ckbkup' is not recognized as an internal or external command,
    operable program or batch file.
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  12. #12
    Join Date
    Sep 2003
    Posts
    237
    The command is db2ckbkp(runs on windows also). Please look in Command reference(db2n0x82)
    mota

  13. #13
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by JDionne

    Code:
    D:\Program Files\IBM\SQLLIB>db2ckbkup -h I:\NamBackups\FULL\NAMDWH.0\DB2\NODE0000\CATN0000\20060301\081853.001
    'db2ckbkup' is not recognized as an internal or external command,
    operable program or batch file.
    Copy the entire directory branch beginning with NAMDWH.0 onto the target system, say, into F:\RESTORE. The result should be
    Code:
    F:\RESTORE\NAMDWH.0\DB2\NODE0000\CATN0000\20060301\081853.001
    Then issue RESTORE ... FROM F:\RESTORE...

  14. #14
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    I have found that in a windows environment you will have to duplicate the path from where the original backup was taken. I dont know if the drive leter must also be the same, but I now know that the folders have to be the same as to were you told the DB to backup the DB. I backed up to \nambackups\full. thats what I had to put in the restore script, not all the way to the file just what i put in the backup script. HTH others in the future.
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

Posting Permissions

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