• Create a DB maintainence plan to fulfill this

    1) create a subplan for full backup and schedule it to run Monday

    2) create a subplan for diff backup and schedule it to run from tue - sun

    3) create a subplan for execute T-SQL stsmt / SQL agent to restore the backups accordingly (first full, later subsequent diffrential backups) and schedule it on Sunday post step 2 completion

    4) create subplan for Check DB integrity

    *******:cool:
    Sudhakar