How to set the schedule for differential backup so that last differential backup would not be over written
BACKUP DATABASE [Dynamics]
TO DISK = N'E:\Test BK Diff GP\DYNAMICS_Trn_NewSequentialID().BAK'
WITH DIFFERENTIAL , NOFORMAT, NOINIT,
NAME = N'Dynamics-Differential Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
But this command does not work. Its overwritting the prvious differential back. I want to generate the sequence for differential backup like