backup

[millerwilliam35]

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, how can I do this?

 

[apogoreliy]

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. There are few articles for more information

https://msdn.microsoft.com/en-us/library/ms191495(v=sql.105).aspx

http://sqlbak.com/blog/copy-only-backups/