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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2012-05-07 : 06:45:24
|
| I am testing SQL Server 2008 R2 DB mirroring without a witness server. I have done the testing if the primary failed, then the mirror will become primary. I didn't find any instructions on how to do if the original primary is back on line, how do I switch the mirror server(new primary) back to the health original primary server. Please advice. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-05-07 : 08:25:31
|
| Remember that after the switch the old mirror becomes the new principal. So switching back is just the same:--> ON THE PRINCIPAL SERVER:ALTER DATABASE database_name SET PARTNER FAILOVER- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
|
|
|
Switch roles in DB mirroring