Working with Backups in SQL Serverhttp://developers.de/blogs/damir_dobric/archive/2010/01/09/working-with-backups-in-sql-server.aspxWhen working with SQL Backups there are in general two types of backup: Full , Differential and Transaction - Log ( to be explained later in this post ) . Additionally, it is important to know that the&#160;&#160; recovery model (Database Options) playsenCommunityServer 2008 SP1 (Build: 30619.63)Truncation is not Shrinkinghttp://developers.de/blogs/damir_dobric/archive/2010/01/09/working-with-backups-in-sql-server.aspx#9888Sun, 10 Jan 2010 11:14:43 GMT7e491611-45ad-4dae-a68f-c4cb64439510:9888DamirDobric<p>While working with transaction logs SQL Server is recording every operation in the log file. If log records</p> <img src="http://developers.de/aggbug.aspx?PostID=9888" width="1" height="1">