August 13, 2003 at 8:20 am
Has anybody found a good, step by step instructions on implementing replication? I am tried to implement transaction replication between two servers. I have tried a couple of time unsuccessfully. Thanks for any help you can give. If the question does not tell you, I am kind of new at this.
August 13, 2003 at 6:18 pm
It involves a few steps to be sure. I dont have a complete list, maybe we could start by you telling us how far you've gotten - and what type replication?
Andy
August 14, 2003 at 12:56 pm
I have not done much yet. I have 2 servers, the 1st I will call Prod, and 2nd I will call Dev. Prod I want to be the Publisher, Dev I want to be Distribution Server, and to do the Subscriptions. (I want max work to on the DEV server, min impact to PROD). I have the additonal problem that both servers are on a domain that I have no admin rights, but I have admin rights on SQL Servers. I know that there is a way to make both servers 'trust' each other , but don't remember how. I want to do transaction replication.
Edited by - ghughes on 08/14/2003 12:57:05 PM
August 16, 2003 at 7:55 am
I think you should spend some time trying replication in a true test environment before deploying to production. Adding replication adds some complexity and it does add some load (relatively minor) to the server. Once you publish a table, you're limited in the changes you can make to it - thats just one piece of the complexity it adds.
Getting replication to work between servers is fairly easy, just have the agent account set so that it has access to the other server.
Andy
August 21, 2003 at 8:05 am
I tried to configure my dev server as distrubutor and ran into a error that I dont know what to do about. "SQL Server Enterprise Manager could not configure 'DEV0002' as the Distributor for 'DEV0002' Error 14114"'(null) is configured as Distributor. Does anybody know whats up with this?
Edited by - ghughes on 08/21/2003 08:53:11 AM
August 21, 2003 at 5:22 pm
August 25, 2003 at 8:42 am
Ok, I got past that problem, now I have a new one.
I have used the wizard and 'successfully' created the
DISTRIBUTOR (on machine B). Now I go to Machine A and try
to setup Machine A as Publisher. I go thru the entire
wizard, pick the table to replicate (transactional) and at
the end I get 2 error messages I cant get past!
Here are the errors
===========================================
SQL Server Enterprise Manager could not enable database 'BData' for snapshot or transaction publications.
Error 20028: The Distributor has not been installed correctly. Could not enable database for publishing. The replication option 'publish' of database 'BData' has been set to false.
=============================================
SQL Server Enterprise Manager could not create publication 'Customer Id' from database 'BData'
Error 14013: This database is not enabled for Publication.
Any Ideas? Thanks for any help you can offer!
PS I looked in Microsofts support site without any luck
Edited by - ghughes on 08/25/2003 08:46:27 AM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply