question

narendba avatar image
narendba asked

How to fix orphand users in logshipping standby server?

Logshipping already configured and running... How to fix the orphaned users in seconday server without stopping the logshipping?
log-shipping
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

narendba avatar image narendba commented ·
Great... How we can run the orphaned users fix script on the secondary server as part of recovering
0 Likes 0 ·

1 Answer

·
KenJ avatar image
KenJ answered
You can't update orphaned users while the secondary is still being log shipped - it's still restoring and cannot be changed. If you know your users in advance, you can create an orphaned users fix script on the secondary server that you run as part of recovering the secondary database.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

narendba avatar image narendba commented ·
Great... How we can run the orphaned users fix script on the secondary server as part of recovering?
0 Likes 0 ·
narendba avatar image narendba commented ·
Database in secondary server is in standby stat and now I need to fix the orphan user on secondary database?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.