Hi all,

I ve accidentally dropped an important Database, how could i recover it.. any help on this..

DB2 Version : 8.1.3
OS : Windows 2000 on sp4


thanks
Sn

Also let me know how to take back up for a database..

regards
Sn

Try to get the backup of the PC if you don't have one of the database itself. If there are no backups available, things look grim. Perhaps DB2 puts the files of the dropped database in the trash can of Windows?

If not, you could try to recover the deleted files with some kind of UNDO tool. I remember there were several of them available in the old win 3.1 time, but thats's a long time ago. I wouldn't use that PC too much to prevent the accidential overwrite of those precious deleted files.