Sql Server differential backup : Simple vs Full recovery model
Posted
by MaxiWheat
on Server Fault
See other posts from Server Fault
or by MaxiWheat
Published on 2010-05-26T13:37:11Z
Indexed on
2010/05/26
13:41 UTC
Read the original article
Hit count: 354
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
© Server Fault or respective owner