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 |
|
ps2ali
Starting Member
21 Posts |
 Posted - 2012-04-24 : 12:43:35
|
| HI i have installed 2 domain controllers one is PDC and second is BDCand i installed sql server 2008 R2 standard edition on both servers, so now i'm actually working on one database witch is installed on PDC, i want now to replicate my database into my BDC,first of all , i have to configure my Distributer on PDC and my Publisher on BDC.it's right?if not tel me how.thank youIT Engineer |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-24 : 12:51:18
|
| Sounds like your publisher is on the PDC.If you aren't going to use a dedicated distributor, put distributor on same box as publisher.Not usually a good idea to put SQL Server and DC on same box. |
 |
|
|
ps2ali
Starting Member
21 Posts |
Posted - 2012-04-24 : 13:05:32
|
| i know its not recomended buti have just 2 server :(and the subscriber on BDC i think, it's possible!IT Engineer |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-24 : 15:06:51
|
| Definitely possible. Be sure to set the max memory in SQL to leave some RAM for the other applications on that box. |
|
|
|
|
|
|
Replication sql server 2008 R2 standard edition