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 |
|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 2012-08-27 : 17:25:41
|
| Since replicating large amounts of data on very busy servers, may require a set up a dedicated box to be our distribution database and thinking of the future, I would like to setup a dedicated server for distribution database. I have 3 servers, sqlserver 5 which will be distributor database, sqlserver 3 which will be the publisher and sqlserver 4 is the Subscriber. What would be my steps to create this enviroment? Is this possible in sqlserver 2008R2 ?Tried the above process already and error states Database 'distribution' does not exist. Make sure the name is entered correctly. Changed database context to 'dbname'(Microsoft SQL Server, Error 911). I created distribution database on server 5 and tried to create the publication database on server 3 where the databases already exist and was planning to create subscriber database in sqlserver4.So failed to create the publication database |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-08-27 : 23:16:56
|
| http://msdn.microsoft.com/en-us/library/ms151866(v=sql.100).aspx |
 |
|
|
|
|
|
Create separate distribution database issues