September 8, 2009 at 12:31 am
Hi All
There is one scenario that is asked by interviewer in one interview
My Server which is running on server 2003 is totally crashed and I have only one full database backup of two days old and the mdf file is totally damaged and now we have only one ldf file.
What is option to recover whole data up to time.
Please Help me
Thanks & Regards
Ghanshyam
September 8, 2009 at 12:43 am
Look up Tail-log backup in SQL's books online (I'm not going to outright give you the answer to an interview question)
However that's only an option if the DB is in full recovery and, if the DB is in full recovery there's unlikely to be just a 2 day old full backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2009 at 12:55 am
When you get the answer, post it, i would be interested to know what you come up with 😛
Had a quick look at what you suggested Gail, very interesting, nice to know
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply