| Author |
Topic |
|
eteune
Starting Member
5 Posts |
 Posted - 2006-10-10 : 16:41:38
|
| I have a Publisher database which is also a Distributor.I want to initiate a mirroring session with this box as the Principle and with the mirror on a separate box.In the case of a failure of the Publisher/Distributor box, the mirror will take over of new Principle of the mirroring session, but will it take over the Publisher/Distributor role as well?Can I continue to have the Distributor be on the Publisher box or must I separate them?thanks,Ed |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 16:44:16
|
| I'm confused. You say your publisher database is also the distributor. Do you mean that the distribution database is on the same server as the publisher? If so, then database mirroring doesn't impact this as it is on the database level and not instance level.Tara Kizer |
 |
|
|
eteune
Starting Member
5 Posts |
Posted - 2006-10-10 : 16:53:49
|
quote:
Originally posted by tkizer
I'm confused. You say your publisher database is also the distributor. Do you mean that the distribution database is on the same server as the publisher? If so, then database mirroring doesn't impact this as it is on the database level and not instance level.Tara Kizer
So should I mirror both the Publisher and the Distributor Databases on the other box? Will that allow me to quickly get the other box up as the new publisher and distributor box? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 16:54:48
|
| I haven't done that. You should test it.Tara Kizer |
|
|
|
eteune
Starting Member
5 Posts |
Posted - 2006-10-10 : 17:04:28
|
quote:
Originally posted by tkizer
I haven't done that. You should test it.Tara Kizer
Yes, of course I will test it first.I was just wondering if anyone knew about this. I have to present a solution for it at work before testing.thanks,Ed |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 17:16:27
|
| I don't think it'll work as the distribution database has server names in it, such as in MSsubscriber_info.Tara Kizer |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-10-10 : 17:24:13
|
| Check out the Books Online topic "Replication and Database Mirroring"Paul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
eteune
Starting Member
5 Posts |
Posted - 2006-10-10 : 17:27:10
|
quote:
Originally posted by tkizer
I don't think it'll work as the distribution database has server names in it, such as in MSsubscriber_info.Tara Kizer
This from:http://msdn2.microsoft.com/en-us/library/ms151799.aspxWhen a publication database is mirrored, the replication metadata stored in the mirrored database is identical to the metadata stored in the principal database. Consequently, for publication databases enabled for replication at the principal, the Publisher instance name stored in system tables at the mirror is the name of the principal, not the mirror. What I am wondering is if I can do the same for the Distributor database. |
|
|
|
eteune
Starting Member
5 Posts |
Posted - 2006-10-10 : 17:30:47
|
quote:
Originally posted by paulrandal
Check out the Books Online topic "Replication and Database Mirroring"
exactly where I am digging  |
|
|
|
|
Mirroring a Publisher in Replication