Backups & Restore..

  • I know how to take Full backuo & differential backup..

    But the problem here is how do i go and automate the below strategy?

    Monday - Full Backup

    Tuesday to sunday - Differential backup

    Now once this is done...

    I want to test restore this...

    Like i will restore a FULL Backup first & then only the differential backup of sunday...

    How do i automate this is one go 🙁

    I have got many sites but i didnt get a step by step link 🙁

    ************************************
    Every Dog has a Tail !!!!! :-D

  • If you don't want to write your own scripts, there are many available on Google and on this site. Search a little 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • If you're not writing your own scripts, you should look to Olla Hollengren or Michelle Ufford. Each person has a set of scripts. I think Olla's are more complete and Michelle's are easier to understand and modify.

    As to scheduling these events, use SQL Agent. You can create multiple jobs, each with a schedule, or you can add multiple schedules to a single job.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • 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

  • Thanks All, will try to make a plan & move 🙂

    ************************************
    Every Dog has a Tail !!!!! :-D

  • Ceating many subplan instead of configure any one of the HA method between primary & secondary server.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply