vinnnu88 (12/9/2016)
Thank you for your quick response..You are right we have one full backup for a week and diff backup daily..
Now assume that we are taking log backup for every 30 min.. and the database crashed at 10:25 AM..
we will be having the latest log upto 10:00 AM.. then how about remaining 25 min data?
You can do a recovery for the remaining 25 minutes of data, but there is no guaranty.
You need a tail log backup.
Read this https://msdn.microsoft.com/en-us/library/ms179314.aspx
and this http://www.sqlskills.com/blogs/paul/disaster-recovery-101-backing-up-the-tail-of-the-log/
and then maybe you'll manage to return it.
Igor Micev,My blog: www.igormicev.com