+ Reply to Thread
Results 1 to 3 of 3
  1. Junior Member
    Join Date
    Jul 2003
    Posts
    4

    Certifications
    A+, CNA
    #1

    Default Transaction Recovery Question

    Oh!

    I just deleted 1000 transactions from my inventory database by accident.

    The lastest backup i have is from last night.

    How can i recover these records.

    Please help?
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2003
    Location
    Toronto
    Posts
    1,160

    Certifications
    MCSD, RHCSA
    #2
    ahmm... sorry dumb terminal. you might have noticed that I've changed the subject of your post. Well the Question of the Day thread is for questions you have answers for only. Very official with exam objectives. I'm sure we'll get somone to answer your questions for you. I'll give it a try too.

    You'll have to do a transaction log recovery for sure if you haven't backed up the rows you've deleted accidently. But i'll have to do a little confirmation on that part.

    In the meanwhile, thanks for joining TechExams.
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Oct 2006
    Location
    Novi Sad, Serbia
    Posts
    10
    #3
    you are right
    only way to get back the data is to do a transaction log back-up. if there is a full back up made before. if not. sorry

    if there is a full back up then you do a transaction log backup. to recover the data you restore the data files then do the transaction log's restore with no recovery and on the last transaction log restore you do with recovery

    note: I'm not an expert I'm prepareing for the exam myself
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks