I found a interesting article about various types  of Back up in SQL 2008 , Incremental, Differential & Full which contains syntax as well. This is useful while setting up SQL Server Management…