Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Lightbulb Unanswered: Rolling back in SQL Server

    One of our engineers here by mistake deleted some very important data without any begin trans block and we need the data back very badly.. We have not closed the session as of now.. The engineer was logged in as sa to the DB.

    Can someone please help soon on urgent basis...

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Rolling back in SQL Server

    Originally posted by hemantmadaan
    One of our engineers here by mistake deleted some very important data without any begin trans block and we need the data back very badly.. We have not closed the session as of now.. The engineer was logged in as sa to the DB.

    Can someone please help soon on urgent basis...
    what is the recovery model for the database and do u have anybackups?

  3. #3
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Talking

    try using lumigent log explrer...

    this tool can generate the script for deleted data from ur log file....


    find the tool from www.lumigent.com

    Cheers in odd time also...

    Deepak K
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  4. #4
    Join Date
    Feb 2004
    Posts
    3

    No Backups

    unfortunately I dont have any backups.. I know my mistake geeks.. but this is what the situation is.. I am trying the log explorer now.. any other suggestions please

  5. #5
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Talking

    yes u can recover from another way..

    1) restore latest full db backup on second server.
    2) take log backup of production server.
    3) restore log backup on secondry server, over full backup.

    4) get the deleted tables(copy them else where)
    5) place them on production server.


    if u still have doubts, reply soon

    Deepak K
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  6. #6
    Join Date
    Feb 2004
    Posts
    3
    I tried to use the lumigent log explorer.. but it is an evaluation version which supports only Northwind.. I even renamed my production DB to Northwind including renaming physical and logical file names.. still it is not possible to use the new [Northwind] with the explorer... any clues...

  7. #7
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    hehehehehe...

    lumigent is not a fool company... u will have to buy its licence. or try to find it.


    well find out if you have any full backup of db and confirm that u have never deleted transaction log till then. then only u can retrieve ur data.

    cheers!!

    Deepak K
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

Posting Permissions

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