InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 12:25:11 GMT20http://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspxIt says in the article that : "Transaction log backups – [b]makes a copy of all the log records [/b]inserted into the transaction log since the last transaction log backup ([u]or [b]database checkpoint, if working in SIMPLE recovery mode[/b])[/u]."as long as I know, there is no way to take transactional backup from a Database with simple recovery model.although, it said in the beginning of the paragraph, that it's not applied when in simple recovery model, is there a point to mentioning this afterward ?Thu, 08 Sep 2011 00:06:35 GMTsina_hshttp://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspxThanks Paul-that means there is actually way to confirm that particular transaction was backed up.But still there is no warrantee that all changes were backed up.Wed, 07 Sep 2011 21:24:15 GMTYuri55http://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspxCorrect - the only way to know whether a transaction is wholely contained within a data backup is if the LSN of the commit log record is within the range of LSNs backed up by the backup.Wed, 07 Sep 2011 21:07:21 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspx"Essentially, both full and differential backups only back up the data, although they do also back up enough of the transaction log to enable recovery of the backed up data, and [i]reproduce any changes made while the backup was in progress."[/i]Please correct me if I am wrong but it seems I read that it's impossible to say whether all changes made during backup are actually were backed up. ThanksWed, 07 Sep 2011 20:58:28 GMTYuri55http://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspxOne correction on this - after switching from simple to full or bulk-logged, you can restart the log backup chain with a differential backup instead of a full backup, as long as a full backup has already been performed at some point in the past. A full backup is not required.Wed, 07 Sep 2011 07:52:08 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic1118784-1173-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/73779/">Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery</A>[/B]Thu, 02 Jun 2011 08:40:17 GMTTony Davis