January 5, 2010 at 6:48 am
Hello,
I have a scenario, let's take an example log shipping is suppose to happned for log1, log2, log3, log4, log5, log6 and log7.
now, untill log1, log2 and log3 everything happened perfectly ok.
Log3 and log4 didn't take place ( failed because of some reason(s)).
Log5 onwards it again started to work fine....
so now in this scenario how should i keep both the servers in sync.
Appreciate if you can send me step by step process for the same.
Thanks.
Rgds,
Pankaj
January 5, 2010 at 8:16 am
This is very urgent so appreciate if anyone can help on this.
Rgds,
Pankaj
January 5, 2010 at 9:37 am
pankaj.baluni (1/5/2010)
Hello,I have a scenario, let's take an example log shipping is suppose to happned for log1, log2, log3, log4, log5, log6 and log7.
now, untill log1, log2 and log3 everything happened perfectly ok.
Log3 and log4 didn't take place ( failed because of some reason(s)).
Log5 onwards it again started to work fine....
Could you clarify " log3 and log4 didn't take place and log 5 onwards worked fine"?
There are log backup, log copy, and log restore three operations for a single logshipping cycle; failures could happen in any of the three; you would need to follow different steps to fix depending on which link fails.
January 6, 2010 at 1:28 am
log backup for log3 and log4 didn't happen. Appreciate your quick detailed reply on this.
Furthermore, if you can seperately mention the steps for all three, would be much appreciated... Thanks
1 - Log Backup Failure -
2 - Log COpy Failure -
3 - Log Restore Failure -
Rgds,
Pankaj
January 6, 2010 at 9:00 am
Hello Experts,
Someone please help on this as it is very important and urgent.
Rgds,
Pankaj
January 6, 2010 at 11:02 am
pankaj.baluni (1/6/2010)
log backup for log3 and log4 didn't happen. Appreciate your quick detailed reply on this.Furthermore, if you can seperately mention the steps for all three, would be much appreciated... Thanks
1 - Log Backup Failure -
2 - Log COpy Failure -
3 - Log Restore Failure -
Max Wei is asking where in the logshipping process the process failed for logs 3 and 4?
For example is if it failed at step 1 - the log backup on the primary database didn't take place for logs 3 and 4 and no log backup was taken, when the log backup is taken for log 5 it will contain all the transactions that should have been included logs 3 and 4. and as long as the copy and restore steps worked successfully then LSN will match up and the databases will be in sync.
If log backup run for logs 3 and 4 but the copy job failed for logs 3 and 4, and the backup and copy process run sucessfully for Log 5 then the restore process will fail because the LSN (log sequence numbers) will not match up.
If all log backups for logs 3 4 5 have been taken and copied over to the secondary server successfully and the restore process has failed you will need investigate why, if the secondary DB is in read-only mode I would look for existing connections.
Hope this helps.
Gethyn Elliswww.gethynellis.com
January 7, 2010 at 12:36 am
GRE-452109 (1/6/2010)
If log backup run for logs 3 and 4 but the copy job failed for logs 3 and 4, and the backup and copy process run sucessfully for Log 5 then the restore process will fail because the LSN (log sequence numbers) will not match up.
Many thanks to your for the detailed answer.
please also tell me what steps should i take to correct this copy issue....
Rgds,
Pankaj
January 7, 2010 at 12:48 am
this means ur copy job is failing, isn't it?
can u please give the error.so that we can provide u the exact solution
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply