Recover from tail log backup

BACKUP LOG lastbackup TO DISK='C:\lastbackup_Tail.trn' WITH NO_TRUNCATE or you can use fn_dblog() function. which is an undocumented function but can be helpful to view SQL Server transactions. see this article to know how to view transaction logs using fn_dblog() http://www.sqlservercentral.com/blogs/zoras-sql-tips/2015/05/28/forensic-analysis-for-log-files-in-sql-server/[/url]