November 17, 2008 at 10:46 pm
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.............:)
November 17, 2008 at 11:15 pm
Amit Gupta (11/17/2008)
I have a problem , we take a differential backup and restore in another serverdaily 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"
November 17, 2008 at 11:26 pm
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.
November 18, 2008 at 8:38 am
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
November 18, 2008 at 11:00 pm
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"
November 18, 2008 at 11:24 pm
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.
November 18, 2008 at 11:45 pm
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.
November 19, 2008 at 7:43 am
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.
November 19, 2008 at 10:17 pm
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?
November 20, 2008 at 10:02 am
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
November 20, 2008 at 10:06 am
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
November 21, 2008 at 4:18 am
Thanks, if i take 1st #3rd then #2nd then #1 What happen can i lost any data?
November 21, 2008 at 8:01 am
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
November 21, 2008 at 11:11 pm
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?
November 21, 2008 at 11:36 pm
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