January 14, 2007 at 11:23 pm
Hi,
The company I work for delivers their developed software together with two W2K3 servers using SQL Server 2000. These two servers has two roles, production and backup, and if the production server is offline or if anything happens to it, the backup server becomes the production server. When the original production server is back online, it becomes the backup server.
I have struggled with replication on these two machines. What we would like is to have scripts for these servers. These scripts should be general so that they could be run at both servers. The current production server is setup as distributor and publisher, and the backup server is setup with a pull subscription. Also, when the subscriber is seetup, it should update its database from the publisher
Does anyone have general scripts like this?
Best,
/M
January 17, 2007 at 8:00 am
This was removed by the editor as SPAM
January 18, 2007 at 4:39 pm
You can script the replication through Enterprise Manager and also can be done using SQL DMO.
Script the replication when you are running on different server you need to replace the servername.
Enterprise manager/Server name/tools/replication/Generate sql scripts...
MohammedU
Microsoft SQL Server MVP
January 18, 2007 at 4:42 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply