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.

  • Please don't cross post.  Your question is answered here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=190505

    My hovercraft is full of eels.

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

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