differential and full backup

hy can any one please let me know how can i schedule full and difirential backup side by side .i can schedule full backup that i know but i want for few days diffrential and fullbackup to go side by side , as i new to database if some how diffrential not work i can upload diffrential backup.

differential -suppose for diffrential i take fullbackup today and schedule daily differential but twist here is how what if some any how take again full back in some other directory then i will not able to restore dababase,as diffrential is taken after last fullbackup . so i want differential backup should be schedule in that way so it can take differential back from the last back up which i have taken,so if anyone take full bak after my back up i will not have to worry. if any one have script please do let me know .

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sourav Mukherjee7y ago
Hi Tarun, your question is not fully clear to me, but use the feature as "Copy_only" to avoid such collision in your script.

For more information, please do take a look at the MSDN post :
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/copy-only-backups-sql-server?view=sql-server-2017

Hope this helps.