Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2012-05-09 : 12:39:11
|
| Hi all,I've been analysing our in-house Log Shipping documentation, which describes the failover/failback process (from Primary to Secondary and back again), but a comparison of the Technet document...http://technet.microsoft.com/en-us/library/cc966382.aspx ...highlights that ours makes no mention of login resolution. We have two logins ('Archive' + 'Portal' that are common to both the primary and secondary servers, as well as two similarly named users, of which 'Archive' is the main app user.But...when I check the 'Users' folder of any of the user db's, I noticed that only the 'Portal' user seems associated with the 'Portal' loginname - the corresponding value for the 'Archive' user is null.Does any of this mean that, if we need to failover, the app won't be able to login to the Secondary server, even after being repointed by the applications team? Thanks,JB |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-05-11 : 08:14:37
|
| Anyone? |
 |
|
|
|
|
|
Resolving users/logins in Log Shipping