Re: Regarding Logshipping.

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 01/18/05 

Date: Wed, 19 Jan 2005 00:24:51 +0100

Hi

In BOL:, under the Index tab look at "Log Shipping, overview"

At the bottom of the page is the topic "Changing Log Shipping Roles"

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"chinn" <chinn@discussions.microsoft.com> wrote in message
news:269ABA3C-F586-4094-A8B1-FEC59140BACF@microsoft.com...
>
> Hello,
> We are planning to implement logshipping as a failover solution.
> I did the whole logshipping setup and also while setting it up i checked
> the radio button ASSUME PRIMARY ROLE.
> Now the question is assuming all the users have been setup correctly.
> What the correct steps to do in case of failover.
> Like in case the primary is down how do you switch to secondary
> and then backup from secondary to primary.
>
> Thanks in ADVANCE..