Replication on Sql server 2000

[ziggyd]

Hello guys,

Was wondering is someone can point me in the right direction on this one, i want to simulate a replication between two sql 2000 servers, how can i achieve this in the most appropriate way, also how can i use Microsoft message queing service in the setup. All help is highly appreciated,

cheers

-Z

 

[JamesLean]

What do you mean by this?

simulate a replication between two sql 2000 servers

Do you just mean you want to set up SQL Server replication?

--James

 

[ziggyd]

Yes i would like to setup SQL server replication, Any step by step Documentation i can look at ??

thanks
_Z

 

[Catadmin]

Books Online. SQL Server 2000 Administrator's Companion by Microsoft Press, or Microsoft SQL Server Database Administrator cert study guide (my personal favorite) by Sybex.

Sybex gives clearer step by step instructions on how to set up Rep if you know nothing about it, IMHO.

Read the instructions carefully. If you set things up in the wrong order, you'll have to jump through hoops to clear all the sysTable entries for Rep before you can start over and re-install it properly.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???