Restore the database upto last point.

  • One of my database get broke at 10 AM today. I have last back up file which was done at 6/13/05 12:00 AM and then i have two transation log back up which was done at 3:00 AM and 8:00 Am.

    I found out that there were 100 record has been added into database from 8:00am to 10am.

    How can i resotre my database with including this last 100 unsaved record.

    If i recover database from backup file then it apply two log file then i will loose the 100 record. How can i restore my database with included this 100 record. (I read some where that i need to current trasation log back. I tried but it wont let me because my data file is broke).

    How can i retrive my database upto last point. Where is my control file for sql server located.

  • There's an article on this very topic in today's scc.com - have you read it ?!

     

    http://www.sqlservercentral.com/columnists/kKellenberger/restoringtoapointintime.asp







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 2 posts - 1 through 1 (of 1 total)

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