Problems in restoreing the database

[aashiss03]

hi everyone


When i m trying resrore the database system is throwing this error.

[b]RESTORE DATABASE NSWD FROM "C:\db2_backups" TAKEN AT 20080429211406 TO "C:" INTO NSWD WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;




SQL2542N No match for a database image file was found based on
the source database alias "NSWD" and timestamp "20080429211406"
provided.

Explanation:

The backup image file filename consists of a database alias and a
timestamp component. A filename is constructed from the source
database alias and timestamp parameters provided in the Database
Restore call. No filename existed in the source directory that
matched based on the source database alias and timestamp
provided. If this error was received from an automatic
incremental restore then a required image was not found based on
the timestamp and location in the database history.

User Response:

Ensure that the database backup image resides on the media
source. Resubmit the operation by specifying a correct timestamp
to result in a match.

If this error was received from an automatic incremental restore,
check the database history for the corresponding backup entry
and verify that the location listed matches the actual location
of the backup image. Either update the database history and
retry the operation to result in a match or issue a RESTORE
INCREMENTAL ABORT command to cleanup any resources that may have
been created during processing.


please anyone suggest what i will have to do

Regards,
aashiss03

[docdiesel]

Hi,

according to your command line there should be a file like NSWD.0.DB2INST1.NODE0000.CATN0000.20080429211406.001 or NSWD.0.DB2.NODE0000.CATN0000.20080429211406.001in your folder "C:\db2_backups". Check if it's there or what files this folder offers otherwise.

Regards,

Bernd

[aashiss03]

There is no file named NSWD.0.DB2INST1.NODE0000.CATN0000.20080429211406.0 01 or NSWD.0.DB2.NODE0000.CATN0000.20080429211406.001 in the folder "C:\db2_backups".

We have downloaded the database in that folder.
For the database there are 7 chunks of ZIP file.
This is directory structure
C:\db2_backups\NSWD.0\DB2\NODE0000\CATN0000\200804 29

[docdiesel]

Hi,

C:\db2_backups\NSWD.0\DB2\NODE0000\CATN0000\200804 29

Looks like DB2 handles backups in windows very different than in Linux, so I'm afraid I can't help you there. Anyway, if this is the directory structure, then I'm missing the time "211406" and maybe some number "001".

Regards,


Bernd