This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 35%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
I have lost the drive which hosted data file and DB is recovery so I wanted to recover the data till the last point? is that possible with log file alone ?
Yes , do you still have DB on you SQL instance showing Recovery Pending ?
Yes , it is not deleted.
that sounds good.
Please try to follow below link.
Please accept as answer if this helps.
This helps, I took backup with NO_TRUNCATE option.
Appreciate your help.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
... and here is another blog post I wrote a long time ago, with some additional information.:
http://sqlblog.karaszi.com/restore-database-to-the-point-of-disaster/
The answer is you CANNOT just alone recover a database using log file. I am not sure if you read the blog shared by @@Sreekanth Madambath it does a proper restore of a database using tail log backup to get you database in recovery. So the point is unless you have a good backup, just using log file will not give you database back. You need to restore the database to get the data back