May 14, 2013 at 7:35 am
Step 3 is for principle. You can not run that on Mirror since it is in restoring mode.
May 14, 2013 at 7:39 am
Sorry, I wasn't clear, I meant that you need to run Step 3 on the Mirror before you activate the mirroring session.
Actually, just thinking about this some more, when you manually failover, is the user present in the database, but as an orphaned user? If so, you can just run
sp_change_users_login @Action='update_one', @UserNamePattern='your_user', @LoginName='your_login'
May 14, 2013 at 7:53 am
I think I am missing something. When you restore DB in mirror, you do that with recovery switch enable. SO it will always be in restoring mode.
May 14, 2013 at 7:55 am
Yes, see my edited post.
May 14, 2013 at 7:59 am
Yes. That was what I was doing. But I wanted the fail-over to be seamless. Without getting me involved at any time.
May 14, 2013 at 8:03 am
Now I'm missing something because you stated in your original post that you had to manually assign the roles, not link the user to a login...:ermm:
Anyway, you've resolved the problem so probably best that we all move on!
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply