June 14, 2005 at 11:58 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 12:40 pm
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