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 |
|
akarra
Starting Member
15 Posts |
 Posted - 2009-12-02 : 20:00:16
|
| Hi,could you please tell me the steps to be followed to activate/switchover to secondary server and make it primary. my architecture is as belowwe have 2 servers and one is primary and another is secondary serverthe secondary server has log shipping configured.i know some of the steps but need a detail steps to make sure that it will be up and running as primary one.An early response is much appreciated.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
akarra
Starting Member
15 Posts |
Posted - 2009-12-03 : 08:11:51
|
| Thanks so much Tara. But if I want to check whether the users are in sync or now how can I do that. The below are the steps iam going to follows. Iam ok with all steps except the last step (9th) one how could I check and synchronize the db users.1) stopping and disabling the transaction-log copy and restore jobs on ther secondary server2) stopping the alerts related jobs to avoid the alerts3) backup the active transaction log on the primary server with norecovery5)restroing the secondary server's database with recovery8)executing the resolve logins job9)enabling synchronization of the logins and database user[/b]Thanks very much in advance. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
akarra
Starting Member
15 Posts |
Posted - 2009-12-03 : 12:48:23
|
| Thanks tara.have a nice day. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
secondary server switch over