I have some backups scheduled on my sqlserver.most of them are differentail backups.But among them some have options 'Append to media' and some of them are 'Overwrite existing media '. But i dont know which of them falls into which category.How can i find that and can i cahnge 'Append to media' to 'Overwrite existing media '?If yes how can i do that?Does it effect my db if i change it?
INfact which one is the best option ('Append to media','Overwrite existing media ') among these two?
you need to identify your app requirements, retention resources availabilities, disaster recovery processes (if exist, else - develop them based on business needs), and then tailor your backup strategy to the above. looks like you inherited the box(-s) from someone else and nothing is documented.