SQLTeam.com | Weblogs | Forums

Backup


#1

Hello, all. I do a Full Backup every day of my Database. I am trying to use the previous Full backup to set up an additionnal Differential Backup, but can't do this properly... Can you suggest something? Thanks in advance


#2

I would suggest you to do the daily backups as copy_only, so that it doesn't break the chain for transaction log backups or differential backups. After that the daily full backup won't be taken into account as basis for the differential backups.


#3

Transaction Log backup is independent of Full / Differential backup, so neither will break the chain for TLog backups.

So you mean that 1) you are taking a differential backup, for example, in the middle of the day, based on a Full Backup taken last night?

Or that 2) each day you want to take a Differential Backup based on e.g. Last Sunday's Full backup? (i.e. and you want to take a Daily Full backup)

In the second case I can't see any benefit (i.e. having to restore using Sunday Full plus Today's DIFF as compared to just restoring Today's Full), but if I'm missing something please let me know