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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2007-03-25 : 23:46:33
|
| hiI have a DB mirror in High performance mode. my principle is down and use: ALTER DATABASE AdventureWorks SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS on the mirror to serve as a database. Now my orginal principle is up and i want my original mirror to be mirror again.How do i go about it? Thanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-26 : 10:50:37
|
| Ideally you should perform the manual failover when both servers are still working. Only use the FORCE_SERVICE_ALLOW_DATA_LOSS option on the mirror if the principal has gone down unexpectedly.When both servers are up you can perform manual failover from whichever one is currently the principal. So in your case now: 1. Start the original principal2. Connect to the original mirror, which is now functioning as the principal3. Issue the following on the principal (the original mirror)ALTER DATABASE AdventureWorks SET PARTNER FAILOVER |
 |
|
|
|
|
|
High Performance Mode