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 |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2009-03-20 : 11:28:02
|
| Hi,I am trying to setup database mirroring. does database mirroring allow you to mirror database A on server 1, to datbase B on server 2? When I try to connect to the second server, I don't see the option of choosing a specific database destination. Please help.Thanks |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-20 : 18:35:46
|
| Not sure what you mean here .. A database that is mirrored can only be accessed from server that is principle for the database.So in a configuration of Server1-Server2 with Server1 being principal; the database A can only be read from Server1. It is not a load balancing. If you have Database B mirrored you can have Server2-Server1 with Server being principal; then you can access Database B from Server2.Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2009-03-20 : 19:50:51
|
| Database A is mirrored as database A on Server 2 as well..you cannot have different name for a mirrored database. However when you break the mirroring you may want to rename it, which is an option.TechnologyYogihttp://gvphubli.blogspot.com/ |
|
|
|
|
|
|
Database mirroring