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 |
 |
|
|
|
|