setting up mirroring on 2 different servers
How can a database be mirrored on 2 different servers. I am not talking about a witness server. I am talking about 2 mirrors running simultaneously, from the same database, How can that be set up. what are the steps, any help will be appreciated.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 5, 2009 3:14 PM
UPDATED:
January 6, 2009 7:43 AM
RELATED QUESTIONS
- How do I configure VMware guestOS(s) to talk to Vista Home Premium as a Host to access DB2 or any other database?
- SQl Server 2008 standard Mirror architecture, fail over without changes in applications
- sql server 2005 mirroring
- How to deploy printers using Windows Server 2008 Group Policy Preferences
- SQL SERVER Data Files and Threads
Answer Wiki:
It can not be done. Database mirroring only supports mirroring to a single destination. If you want to ship the data to more than one destination you have to use Log Shipping or Replication.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
