Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to better understand the backup process under SQL Server 2008. Since drive space is a kind of matter for us and we want to have a better disaster recovery solution, I decided that we will implement differential backups throughout the day (every hour).

Am I right to think that if I keep the recovery model of my databases to Simple, the differential backup will be almost the same size as Full Backup (too big to make one every hour) ? I already tried to switch to Full recovery and it seemed to have fixed the issue (differential backups were way smaller). I heard that the recovery model must be set to Full to use Log backups (to the minute recovery etc., but we don't need that) but never about differential backups.

So, is the recovery model really having an impact on differential backups or am I missing something ?

Thank you

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

Under the simple recovery model differential backups can only have a single base. You can have multi-based differential backups (see Working with Multibase Differential Backups for some details) using the full recovery model.

share|improve this answer
    
Thank you, your short answer and link helped much! –  MaxiWheat May 26 '10 at 18:17
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.