It sounds like you're taking a full backup every time you take a backup. In my environments, I typically take a full backup once a week and differential backups the other days. A differential backup backs up changes since the last full backup (not, as some people assume, since the last differential!). In order to do a differential backup, you need only add the with differential clause to your normal backup. So something like:

backup [myDB] to disk 'c:\temp\myDB.bak' with init --full backup
backup [myDB] to disk 'c:\temp\myDB_diff.bak' with init, differential --diff backup


I should note that in order to restore in this scenario, you need to restore the full backup with the with norecovery clause and then restore your differential. So something like:

restore [myDB] from disk 'c:\temp\myDB.bak' with norecovery --full backup
restore [myDB] from disk 'c:\temp\myDB_diff.bak' with recovery --diff backup


Incremental backup of FILESTREAM data?
What is the isotope composition of hydrogen atoms in the sun? Are the ratios of protium:deuterium:tritium similar to those we find on earth?

What does the nuclear fusion of hydrogen atoms in the sun look like? Can protiums participate too? Where does, then, the helium atom get a neutron from, as there are no neutrons in protiums?
