Replication scripts

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

Sorry, it's not clear to me exactly what the problem is. Did you try setting up replication using the wizards? Once it's set up, you can script out the replication scenario in Enterprise Manager.|||

Is replication a part of the solution, or something you need to setup?

Would setting up Database Mirroring between these 2 servers be an option? If do then please refer to http://msdn2.microsoft.com/en-us/library/ms177412.aspx.

This posting is provided AS IS with no warranties, and confers no rights.