Back-up image is not visible when restoring database

[vikram1102]

whenever i try to restore the database from a backup image, i cant find the backup image which was created during backup process.
wat will be the proces to recover the database from the bachup image if the database is dropped.

[ramesh jampala]

whenever i try to restore the database from a backup image, i cant find the backup image which was created during backup process.
wat will be the proces to recover the database from the bachup image if the database is dropped.

Hi Vikram,

Are you providing the backup image path in the restore command?
If the database is dropped, use the following command for restore...

db2 restore database dbname from backuppath taken at timestampofback upimage into newdbname without prompting

backuppath is where you stored your backup image like c:\db2backups

[vikram1102]

Hi Vikram,

Are you providing the backup image path in the restore command?
If the database is dropped, use the following command for restore...

db2 restore database dbname from backuppath taken at timestampofback upimage into newdbname without prompting

backuppath is where you stored your backup image like c:\db2backups

Thanks buddy.. its working... , but if i want to restore some database from control center after deleting , then the backup image is not visible, can u make it for me....

[ramesh jampala]

Thanks buddy.. its working... , but if i want to restore some database from control center after deleting , then the backup image is not visible, can u make it for me....

Vikram,
From Control center, if the backup image is not visible means it is not there in recovery history file. Choose Manually enter the backup image information radio button. This will allow you to provide the backup image when you know the path where it was stored.

[vikram1102]

Vikram,
From Control center, if the backup image is not visible means it is not there in recovery history file. Choose Manually enter the backup image information radio button. This will allow you to provide the backup image when you know the path where it was stored.

u r a genious..... ;)