InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:34:32 GMT20http://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxMy Pleasure!Please do post if you have any errors, we would be able to help you outFri, 06 Feb 2009 14:18:29 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxThank u krishnaFri, 06 Feb 2009 00:49:23 GMTn.yarramreddyhttp://www.sqlservercentral.com/Forums/Topic651413-146-1.aspx[quote][b]n.yarramreddy (2/6/2009)[/b][hr]Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?[/quote]BACKUP LOG WITH NO_TRUNCATELook in BOL to understand the concept before working on it.Fri, 06 Feb 2009 00:45:17 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxBakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?Fri, 06 Feb 2009 00:40:07 GMTn.yarramreddyhttp://www.sqlservercentral.com/Forums/Topic651413-146-1.aspx[quote][b]Krishna (2/6/2009)[/b][hr]and finally Tail Backup with STOPAT (Recovery)[/quote]You only need STOPAT if there are some commands in the log that you don't want to restore (for eg a user dropping a table). If there are no such commands, leave out STOPAT and restore the entire log tail.Fri, 06 Feb 2009 00:10:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxThank youFri, 06 Feb 2009 00:05:39 GMTn.yarramreddyhttp://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxThe Order goes like this:Bakcup the Acitve portiong of the log(Tail log)Recent Full backup(No Recovery)Recent Differential backup(No Recovery)Latest Tlog backup(No Recovery)and finally Tail Backup with STOPAT (Recovery)Fri, 06 Feb 2009 00:04:49 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxDepends how the DB crashed.If the log is still accessible and SQL's still running, then you back up the tail of the log (no truncate, no recovery options), and restore that as the last log backup when you restore the database.If the log is not accessible (say the log drive failed), then you cannot retrieve that last 15 min of data.Fri, 06 Feb 2009 00:01:56 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic651413-146-1.aspxsuppose every night i am taking full backup ,every 2 hours taking differnetial backup.every 1 hour taking transcation log backup. I have transcation log backup up to 01:00PM..but my database is crashed on 01:15PM.How to retrive the 15 Mins Data.Thu, 05 Feb 2009 23:56:14 GMTn.yarramreddy