sql-server-2008 whats the point of doing full backup if i can just do differential backups

we do full backups daily. what is the point of doing full backups if we can just do differential? this is a newbie question, i do not mean for this to be too much of a profound question. your answer should be simple,.

You need a full backup in order to do either differential backups and/or transaction log backups. I think an example on how you can use them would be more beneficial.

Let's assume you have a 500GB database. Performing a full backup every night would use a high amount of system resources. Unless all of the data is constantly changing, the only thing you really need is the last days worth of changes. This is where a differential may come into play. What you might do is take 1 full backup on Sunday. All 500GB. Now Mon - Sat, you can perform a differential backup each night. What you'll end up with is a cumulative backup of changes to the database each night from the last full backup that are significantly smaller in size. So on wednesday, you'd have mondays, tuesdays, and wednesdays changes all rolled up in wednesday nights differential backup. To restore, you'd restore the full backup from sunday, and then the wednesday differential backup.

Now let's say you have a recovery point objective (how much data loss is acceptable) of 1 hour for your data. Just having a full and diff backup 1 time a day is not sufficient. This is where you could implement transaction log backups into the mix. You could perform these daily every hour. So let's assume you have a failure at wednesday 3:15 AM and your full backup is done Sunday at 1AM and diff backups are performed at 1AM daily. To recover you'd have to restore Sundays full backup, Wednesdays diff backup, and then the 2 transaction log backups (2AM and 3AM). This scenario would get you back to 15 minutes before the failure.

Hope this helps you understand the difference and how you can use the different backup types.

Differential backups allow you to have an intact backup chain without using as much space as a full backup would. They still require a full backup to complete a restore, because the differential backup backs up the differences between the database and the last full backup.