April 6, 2009 at 5:14 am
i'm new to logshipping i've configured log shipping.
problem is the staging database is in restore status, how can i remove this status.
is there any problem with the scheduling of backup/restore jobs.
🙂
April 6, 2009 at 6:14 am
vrabhadram (4/6/2009)
i'm new to logshipping i've configured log shipping.problem is the staging database is in restore status, how can i remove this status.
is there any problem with the scheduling of backup/restore jobs.
It's not a problem, it is the way you have to set up log shipping.
Log shipping secondary can be in two states:
Recovery
Standby
When it is in recovery status you would not be able to access the secondary it is just to maintain redundant data.
When it is in Stand by status, you would be able to access the secondary database
What is your purpose of your logshipping?
April 6, 2009 at 7:15 am
Krishna Potlakayala (4/6/2009)
When it is in Stand by status, you would be able to access the secondary databaseWhat is your purpose of your logshipping?
In addition to what Krishna said, Standby mode will provide Read Only access to the log shipped database.
What is the business requirement that you are trying to achieve here?
Cheers,
April 6, 2009 at 9:25 pm
HI,
Thanks for ur answer. i need to be standby server should be the readonly. how can i change? if i want to set standby/readonly at the time of log shipping. is there any helpful link please provide.
Thanks.
🙂
April 7, 2009 at 1:48 am
Hi,
You should be able to find what you are looking for here:
April 7, 2009 at 2:58 am
hi,
thanks for your suggested links.it's so useful to me.
🙂
April 7, 2009 at 2:59 am
You're welcome. Glad to help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply