By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

Back-up image is not visible when restoring database

P: 14
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.
Mar 27 '07 #1
Share this Question
Share on Google+
4 Replies


P: 10
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 timestampofbackupimage into newdbname without prompting

backuppath is where you stored your backup image like c:\db2backups
Mar 27 '07 #2

P: 14
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 timestampofbackupimage 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....
Mar 28 '07 #3

P: 10
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.
Mar 28 '07 #4

P: 14
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..... ;)
Mar 29 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.