Post reply

How the data is stored in Full backup its a backup strategy

  • September 19, 2014 at 2:45 am

    #148502

    Hi all,

    How the data is stored in Full backup it is Production server standard edition

    backup Strategy is like

    Full backup on sunday10am

    diff daily monday

    diff daily tuesday

    diff daily wednesday

    diff daily thursday

    diff daily friday

    diff daily saturday

    what will store in full backup and diff backup and how will the data stores in Full backup

    Thanks

    Naga.Rohitkumar

    Thanks
    Naga.Rohitkumar

  • September 19, 2014 at 3:20 am

    #1746632

    Why does it matter how the data is stored in the full backup?

    Full backup is just that, a complete copy of the entire database. Diff backup contains the changed extents since the previous full backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2014 at 3:22 am

    #1746636

    Every differential backup stored all modification since the last FULL backup.

    Restore actions to bring the database back to Thursday using your strategy:

    - Restore FULL backup of last Sunday (with norecovery)

    - Restore DIFF backup of last Thursday (with recovery)

    If you have implemented LOG backups (needed when database is in FULL recovery mode), each and every LOG backup made since the last restored FULL or differential backupfile need to be restored uptill the time you want to recover your database.

    Strategy:

    - weekly FULL backup on midnight Sunday

    - daily DIFF backup on midnight (excl. Sunday)

    - hourly LOG backup

    Restore actions to bring the database back to Thursday 08:00 AM:

    - Restore FULL backup of last Sunday (with norecovery)

    - Restore DIFF backup of last Thursday (with norecovery)

    - Restore 7 LOG backups from thursday 01:00 - 07:00 (with norecovery)

    - Restore LOG backup from Thursday 08:00 (with recovery)

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • September 19, 2014 at 3:25 am

    #1746638

    yep but if some body asks what it the terminology to say

    Thanks
    Naga.Rohitkumar

  • September 19, 2014 at 3:40 am

    #1746649

    Oh, so these are interview questions you're posting here, not a real set of database problems? Good to know.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2014 at 3:47 am

    #1746653

    these are not interview questions

    i was in to a new organization has to handel the entire setup singly there is no other dba to gv support previous dba who leaves from here given me a scenario i said the same wh u replied bt he is not agreeing wt tat so i thought u are the one who can help me out like u do so ealier

    Thanks
    Naga.Rohitkumar

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

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