Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Unanswered: how to recover a dropped database

    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

  2. #2
    Join Date
    Apr 2005
    Posts
    127
    Also let me know how to take back up for a database..

    regards
    Sn

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    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.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •