Post reply

database recovery to point of time

  • May 21, 2005 at 1:39 am

    #164647

    I have a database with lost data due to human error, user executed Create table on existing tables. I have complete database backup (both the .log and .mdf are available) of 4 days back.

    I want to restore the database to current just the time before the user executed the create table commands (time of command execution is available). How to restore this database. Pls Help!!!

    Mohd Mansoor

     

  • May 22, 2005 at 11:03 pm

    #560421

    check what is your recovery model in DB properties window option tab.If it is set to full at the time of back up then only you can perform point in time restore.If it is so as usual in enterprise manager click Database>All task>restore DB then you can select the DB to restore and below you can see the check box point in restore .Check it and enter date and time to which restore when promted.

    Regds

    RMK

  • May 23, 2005 at 12:54 am

    #560432

    Thanks Rafeeque. I had tried that too but didnot work. 

    I have recovered the lost data using Lumigent Log Explorer. Its an excellent tool. I could view all the transactions in the log file and its possible to undo or redo any transaction using this software.

    Regards

    Mohd Mansoor

     

     

  • May 23, 2005 at 7:41 am

    #560487

    Hi Mohd,

    can you help me where can i get that "Lumigent Log Explorer". I want to try that software.

    thanks in advance.

    Regards,

    Arnold

  • May 24, 2005 at 2:04 am

    #560686

    Hi Arnold,

    Pls visit http://www.lumigent.com/ .

    Regards

    Mohd Mansoor

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply