I am a Junior DBA who does not have much experience in SQL. I just started a new job and my boss is asking me to set up a procedure to do the following-
1. Perform Daily Full and transactional Backup.
2. Archive the old backup every day.
Can somebody please help with it.