Saturday, February 25, 2012

No. of Distribution Database

How many distribution databases can we have ? ... Say I have one publisher
/Published DB and multiple subscribers.
Can I have as many distribution dbs as the no. of subscribing dbs or just
one per published db or just one per publisher ? Can someone get my basics
straight ?
Each publisher can have its own distribution database, but only one.
You can have multiple distribution databases per distribution server with
one or more publisher's using each.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
> How many distribution databases can we have ? ... Say I have one publisher
> /Published DB and multiple subscribers.
> Can I have as many distribution dbs as the no. of subscribing dbs or just
> one per published db or just one per publisher ? Can someone get my basics
> straight ?
>
|||So even if the publisher has 4 published dbs, they all write to just one
distribution database.Right ?
Also how easy is to move the distribution db from a local server to a remote
server ?
Also what about once we do move to a remote server and say have multiple
distribution dbs, how easy is it to modify the properties ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Each publisher can have its own distribution database, but only one.
> You can have multiple distribution databases per distribution server with
> one or more publisher's using each.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
publisher[vbcol=seagreen]
just[vbcol=seagreen]
basics
>
|||Also curious to know if multiple publishers can use the same distribution db
?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Each publisher can have its own distribution database, but only one.
> You can have multiple distribution databases per distribution server with
> one or more publisher's using each.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
publisher[vbcol=seagreen]
just[vbcol=seagreen]
basics
>
|||That is correct - all publications from one publisher will use the same
distribution db.
It is simple to move the distribution db from a local server to a remote
one. All you do is drop all publications and subscriptions, disable
replication, reinstall replication and configure it for the remote
distributor, and then recreate all of your publications and subscriptions.
Modifying the properties of a distribution database is simple. It is best
done on the distributor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uOtuzHuFFHA.3648@.TK2MSFTNGP10.phx.gbl...
> So even if the publisher has 4 published dbs, they all write to just one
> distribution database.Right ?
> Also how easy is to move the distribution db from a local server to a
remote[vbcol=seagreen]
> server ?
> Also what about once we do move to a remote server and say have multiple
> distribution dbs, how easy is it to modify the properties ?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...
with
> publisher
> just
> basics
>
|||Multiple publishers by default will use the same distribution database,
unless you select another distribution database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:esvEUJuFFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Also curious to know if multiple publishers can use the same distribution
db[vbcol=seagreen]
> ?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...
with
> publisher
> just
> basics
>

No comments:

Post a Comment