| Author |
 Topic  |
|
|
aliyesami
Starting Member
USA
30 Posts |
 Posted - 11/10/2008 : 11:25:08
|
hi !
I have set up a standby server by migrating system databases so that my standby server has same user logins as primary.
I am reading everywhere the first step of role reversal as "
Step 1: Transferring and exporting logins. First, BOL recommends building a SQL Server 2000 Data Transformation Services (DTS) package to transfer logins from the primary server to the secondary server and to resolve login SIDs across distinct servers"
my question is : do I need to do this step since my logins already match between primary and secondary ?
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
aliyesami
Starting Member
USA
30 Posts |
Posted - 11/10/2008 : 12:47:13
|
hi Tara !
assuming my accounts dont change ..can i skip the step 1 ? |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
role reversal in sqlserver 2000 question
