April 29, 2008 at 1:18 am
Hi,
Will log shipping work with regular back-up maint paln.
If I take regular full,diff and trans log back up with maint plan and same time use log shipping will this work or not?
as when you take any backup , trans log will be deleted so I think it won't work but in book online it is written that with full or diff backup log shipping will work only with trans log backup it will not work.
can someone explain why it is so.. as when you take diff or full back then also trans log will be deleted ... I am little confused...
example :- suppose 10 I take full back up and then have log shipping for 20 min interval and then next backup (diff backup if i take on 10:35 won't it delete all trans log from 10:20 to 10:35 ) so next time won't log shipping be having only log from 10:35 to 10:40)
Help..
Thanks!
April 30, 2008 at 2:20 am
logshipping will work with your maint plan....
all your transcation logbackup iwll be tkane on the priamry server which will then be copied to our stnadby server and applied there....
how you will do is as follows
Primary server.
1. configure full d/b backup
2. transaction log back (depending on the time interval)
Secondary server
1. create a copy job that will copy the transcation log backup to this server. (i guess this will eb done automatically if configure log shippign from the maint plan)
2. you jsut need to restore the abckup from the priamry to this standy the first time to start logshipping.
youc na use stnadbymode or norevcovery mode
hope this helps
July 9, 2008 at 2:36 pm
sharon (4/30/2008)
logshipping will work with your maint plan....all your transcation logbackup iwll be tkane on the priamry server which will then be copied to our stnadby server and applied there....
how you will do is as follows
Primary server.
1. configure full d/b backup
2. transaction log back (depending on the time interval)
Secondary server
1. create a copy job that will copy the transcation log backup to this server. (i guess this will eb done automatically if configure log shippign from the maint plan)
2. you jsut need to restore the abckup from the priamry to this standy the first time to start logshipping.
youc na use stnadbymode or norevcovery mode
hope this helps
I never try this, but it doesn't seem like it makes sense. If your maintenance plan includes a daily full backup and subsequent transaction log backups - the full backup done daily will break the sequence of transaction log backups for log shipping. You'll have to restart log shipping after every full backup, no?
July 9, 2008 at 11:46 pm
hi rookie, wat if one of our log file gets coruptd .....then do we hav to restore the full back and again transaction log ...... as the sequence
e.g the case will be lik
log 1 sucful
log 2 failed or corupt
log 3 sucful
log 4 sucful ...... and so on.... wat need to be done.
July 10, 2008 at 12:40 am
logshipping can be configured using enterprsie amanger if you ahve sql server enterprise edition.
incase of standard edition you will need to run script to configure log shipping.
in case of standard edition there are two main jobs that do the process of creating the stand by db on the secondary server
1. copy job
2. the load job
the same process will happen in Enterprsie edition but i do not know the exact name of the jobs
the copy job just copies all the transaction log abckups to the secondary server.
the load jobs loads the transaction log backups on the dbs.
incase one of the transcation log files gets ciorrut the log sequence qill break.in this case you ahve to restore the full db abckup and then load all the transcation log backups after the full db backup
July 10, 2008 at 1:11 am
bcoz i hv not created log shiping i dnt excatly wat need to be done and wat will be the steps as of now my company wants to create a log shipping can u plz let me no the steps to be follow .... we r using standard edition .... we do bac up log every 1 hr .....
July 10, 2008 at 2:21 am
you can follow this link psoted omn this site
http://www.sqlservercentral.com/Forums/Topic456549-54-1.aspx
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply