DataBase Restore Problem

  • I have a problem , we take a differential backup and restore in another server

    daily through DTS with schedule time but i am not getting right way? so suggest me.

    Thanks in Advance.............:)

  • Amit Gupta (11/17/2008)


    I have a problem , we take a differential backup and restore in another server

    daily through DTS with schedule time but i am not getting right way? so suggest me.

    Thanks in Advance.............:)

    Can u specifically what is happening.

    "Keep Trying"

  • When i am restore diff backup then database not set standby or norecovery.

    me want programatically set norecovery first and then restore then again set with recovery. when i am set norecovery then i am unable to execute any query.

  • Are you restoring a full backup with norecovery before trying to restore the differential backup? A differential backup can't be restored by itself. See RESTORE in BooksOnLine.

    Greg

  • Amit Gupta (11/17/2008)


    When i am restore diff backup then database not set standby or norecovery.

    me want programatically set norecovery first and then restore then again set with recovery. when i am set norecovery then i am unable to execute any query.

    Check out BOL and then give this a try.

    You can set norecovery/standby options in your restore database command.

    "Keep Trying"

  • I know norecovery/standby cmd but its my problem is that until not restore with recovery it not execute any query and when i restore with recovery then i am again unable to restore diff backup.

  • Once you "recover" the database doing a restore with recovery you can no longer apply differential or transaction log backups to the database. You have to redo the restore starting with the appropriate full backup.

  • I'm not quite clear on the problem, but maybe what you're looking for is "STANDBY" instead of "norecovery". then you can run selects because the DB is in read-only, but you can still do more DIFF or T-LOG restores to it.

  • i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st day what happend?

  • Amit Gupta (11/19/2008)


    i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st day what happend?

    Please restate your situation and question more clearly. I don't understand what you're asking.

    Greg

  • Amit Gupta (11/19/2008)


    i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st day what happend?

    If you have 3 diffs, you only need to restore the most recent one, because that contains the data in 1 and 2. After you restore the diff, then you restore all the transaction logs taken after the diff #3

  • Thanks, if i take 1st #3rd then #2nd then #1 What happen can i lost any data?

  • Amit Gupta (11/21/2008)


    Thanks, if i take 1st #3rd then #2nd then #1 What happen can i lost any data?

    I don't understand the question. Are you asking about restoring all the diffs in the wrong sequence ?

    This is an example of a typical backup schedule. A FULL backup is taken once a day. DIFF backups are taken every few hours, and T-LOG backups are taken every 30 minutes.

    FULL Backup 1:00 am

    DIFF # 1 5:00 am

    t-log #1 6:00 am

    t-log #2 6:30 am

    t-log #3 7:00 am

    DIFF #2 8:00 am

    t-log #4 8:30 am

    t-log #5 9:00 am

    t-log #6 9:30 am

    DIFF #3 10:00 am

    t-log #7 10:30 am

    t-log #8 11:00 am

    t-log #9 11:30 am

    Now, if you need to restore the database up to 11:30 when your most recent T-LOG backup was made, these are the steps you would take:

    Restore FULL with no recovery

    Restore DIFF#3 with no recovery

    restore t-log #7, #8 with no recovey

    restore t-log #9 with recovery

  • According to this i restore 1st DIFF #3 then DIFF #2 after this DIFF # 1

    then actually what happen lost any date or successfully restore All data?

  • Based on the following:

    Backup & Restore example:

    FULL Backup 1:00 am

    DIFF # 1 5:00 am -- all changes between 1:00 am and 5:00 am

    t-log #1 6:00 am -- all changes between 5:00 am and 6:00 am

    t-log #2 6:30 am -- all changes between 6:00 am and 6:30 am

    t-log #3 7:00 am -- all changes between 6:30 am and 7:00 am

    DIFF #2 8:00 am -- all changes between 1:00 am and 8:00 am

    t-log #4 8:30 am -- all changes between 8:00 am and 8:30 am

    t-log #5 9:00 am -- all changes between 8:30 am and 9:00 am

    t-log #6 9:30 am -- all changes between 9:00 am and 9:30 am

    DIFF #3 10:00 am -- all changes between 1:00 am and 10:00 am

    t-log #7 10:30 am -- all changes between 10:00 am and 10:30 am

    t-log #8 11:00 am -- all changes between 10:30 am and 11:00 am

    t-log #9 11:30 am -- all changes between 11:00 am and 11:30 am

    Now, if you need to restore the database:

    Restore FULL with no recovery

    Restore DIFF#3 with no recovery

    restore t-log #7, #8 with no recovey

    restore t-log #9 with recovery

    Does this help? Because I have no idea what you are trying to ask with this question:

    According to this i restore 1st DIFF #3 then DIFF #2 after this DIFF # 1

    then actually what happen lost any date or successfully restore All data?

Viewing 15 posts - 1 through 15 (of 18 total)

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