Redirected Restore Error

JDionne · #1 (**permalink**) 03-07-06, 08:39

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?

sathyaram_s · #2 (**permalink**) 03-07-06, 08:49

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

przytula · #3 (**permalink**) 03-07-06, 09:26

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

jhehir · #4 (**permalink**) 03-07-06, 10:26

Don't forget to reference the database that was backed up not the database you might be restoring into.

jhehir · #5 (**permalink**) 03-07-06, 10:26

Don't forget to reference the database that was backed up not the database you might be restoring into.

JDionne · #6 (**permalink**) 03-07-06, 11:51

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

n_i · #7 (**permalink**) 03-07-06, 15:26

What was the backup command that you used?

dbamota · #8 (**permalink**) 03-08-06, 09:57

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:\...

JDionne · #9 (**permalink**) 03-09-06, 07:16

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?

sathyaram_s · #10 (**permalink**) 03-09-06, 07:41

Wherever you file is ...

Sathyaram

JDionne · #11 (**permalink**) 03-09-06, 08:33

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.

dbamota · #12 (**permalink**) 03-09-06, 15:08

The command is db2ckbkp(runs on windows also). Please look in Command reference(db2n0x82)

n_i · #13 (**permalink**) 03-09-06, 15:56

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...

JDionne · #14 (**permalink**) 03-13-06, 10:51

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech