When I backup my Database, I do a Full Backup every day who goes on a tape. I am trying to use the Sunday's Full backup to set up an additionnal Differential Backup, how can I do this? It only takes the last Full Backup.
Full (Run on Sunday) :
BACKUP DATABASE [DATABASE] TO DISK = N'J:\DATABASE Backup\MyDatabase_Full.bak' WITH NOFORMAT, NOINIT, NAME = N'DATABASE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
Partial (Run each Day, but use the wrong Full Backup) :
BACKUP DATABASE [DATABASE] TO DISK = N'J:\DATABASE Backup\MyDatabase_Partial_20120105.bak' WITH DIFFERENTIAL , RETAINDAYS = 10, NOFORMAT, NOINIT, NAME = N'DATABASE-Differential Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10