• Incremental and Differential backups are the same thing, or the terms are used interchangebly.  However, differential backups DO NOT truncate the transaction log, only a transaction log backup does that.  So the first poster is correct, this is not a comprehensive backup solution, but it could easily be made into one...

    The design of the DatabasesBackupStrategy table is very poor.  The odd kind of pseudo bit masking with the 'CCCCCCC' and substring function is very awkward and breaks one of the fundamental rules of database design (atomicity.)  With a bit more thought and/or knowledge one could easily improve the design of this system, making it much more flexible.  What if you can't do either a differential or a full backup daily?  What if you want to do more than one per day?  This design will not address these issues and potentially many others.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/