Script for automation of Backup and Archive Old Backup Dailt

• gttred

  SSC Journeyman

  Points: 83

  More actions

  July 9, 2010 at 2:57 pm

  #221076

  Hi Friends,

  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.

  Thanks