SQL Backup Directory Structure and Copy the files in different folder RRS feed

  • Question

  • Hi,

    We are planning to do daily , monthly and Yearly backup (via Native SQL MP)folder but there is challenges in managing schedule that every month and year there will be daily backup will also be running,  so three backup job will be running in same day.

    So to avoid that we are going to decide that native backups on Daily(till 30 Days ) only and we will move the monthly and yearly backup to respective folder via Scripting(schedule will run monthly an yearly to copy).

    So please give your view how  it should be managed or any script available .



    Tuesday, September 10, 2019 5:54 AM