June 14, 2005 at 10:46 am
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.
June 14, 2005 at 2:08 pm
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