At what step do we need to transfer logins in Log shipping??

Question

At what step do we need to transfer logins in Log shipping??

klnsuddu

SSCertifiable

Points: 5836
More actions
May 11, 2009 at 5:17 pm

#137718

Hello,
Iam trying to configure log shipping of share point databases.
Primary Server: ABC
Instance: INS1
Secondary Server: XYZ
Instance: INS2
Steps:
1.I performed the full backup of all databases except system databases in INS1
2.Copied the Bak files to Secondary Server
3.Restored all the databases with NORECOVERY option.
4.In Step 4, I Script out all the logins and jobs in Primary (ABC\INS1) and transferred to Secondary (XYZ\INS2)
5.Configured Log Shipping for each databases using the Wizard in Primary.
Is the Step 4 is Correct? Or Do we need to run this step after the failover from primary to secondary?
How to failover and fail back here??
Please clarify me..
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

I would think that Step 4 would be done before Step 3, but I could be wrong. If the databases are owned by one of the logins in Step 4 which for Sharepoint a specific login needs to be the owner, you need the login to exist before you restore the database.

maechismo_8514 SSCoach Points: 17510 More actions · Answer 2

You don't have to trasnfer logins while configuring log shipping.

I usually do it once failover from primary to secondary. I make sure that the primary and secondary are synchronised and then as a last step transfer all logins from primary to the secondary.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

Krishna,

Have you done this specifically with Sharepoint? Log shipping isn't my forte, so I am curious how it would work for a product like Sharepoint where the Service account has to be the database owner for the Sharepoint databases, being a db_owner isn't enough.

klnsuddu SSCertifiable Points: 5836 More actions · Answer 4

for a product like Share point where the Service account has to be the database owner for the Share point databases

Here do we need to have sql server Service account as the owner of the Share point databases?

In our case, we have a domain account, which is related to share point server (NOT sql server) and the share point admin used this account while creating the databases when configuring share point application

what are are the default logins created once the installation of sql server is completed in cluster environment

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 5

Jonathan Kehayias (5/11/2009)
I would think that Step 4 would be done before Step 3, but I could be wrong. If the databases are owned by one of the logins in Step 4 which for Sharepoint a specific login needs to be the owner, you need the login to exist before you restore the database.

It would certainly seem that this would be the logical approach if for no other reason that avoid the synch of logins. Can't speak expressly about Sharepoint though.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 6

klnsuddu (5/12/2009)
for a product like Share point where the Service account has to be the database owner for the Share point databases
Here do we need to have sql server Service account as the owner of the Share point databases?
In our case, we have a domain account, which is related to share point server (NOT sql server) and the share point admin used this account while creating the databases when configuring share point application
what are are the default logins created once the installation of sql server is completed in cluster environment

In this case, when I said Service Account, I was referring to the Sharepoint Service Account, which would be the Domain Login that is the owner of your databases.

klnsuddu SSCertifiable Points: 5836 More actions · Answer 7

thanks,

In the DRT location, we are going to install SQL Server and Sharepoint application in the same way as we have in primary location.We have both Primary n Secondary in the same domain and will have same service accounts.

So when we configure sharepoint application, the default databases will be created with Service account logins.Then we will ship the the databases other than the default databases from primary.

is this make sense? plz advice me..

maechismo_8514 SSCoach Points: 17510 More actions · Answer 8

Jonathan Kehayias (5/12/2009)
Krishna,
Have you done this specifically with Sharepoint? Log shipping isn't my forte, so I am curious how it would work for a product like Sharepoint where the Service account has to be the database owner for the Sharepoint databases, being a db_owner isn't enough.

OOpss..oops .....oooopss...What a blunder!!!! my bad Dint notice the question was WRT to Sharepoint. The method above I described was for SQL 2005. Was busy at work and I replied from my work haa...should be careful next time 😀

My sincere apologies......

And I don't have any idea about how it works for Sharepoint databases.

klnsuddu SSCertifiable Points: 5836 More actions · Answer 9

If it is Normal log shipping(Not share point application), transfer of the logins from Primary instance to Secondary instance is the last step After the all the databases on the secondary instance are Online(Restored with RECOVER option) after the failover right? and can we use this script to transfer all logins from primary to secondary http://support.microsoft.com/kb/918992

correct me If I misunderstood...