Guide for Replication in MS SQL Server 2008

sql-server sql-server-2008 replication
Tommy picture Tommy · Apr 15, 2009 · Viewed 40.8k times · Source

I wonder if anyone know/have a good guide for Replication in MS SQL Server 2008?

I want to set up a Replication between two different computers that run MS SQL Server 2008, the master runs on Windows Vista, and the slave will run on Windows XP.

I´ve done this in earlier days, but between two MySQL-servers.

Answer

John Sansom picture John Sansom · Apr 15, 2009

The Microsoft documentation for replication is quite thorough. I would suggest using the following link as your starting point and then selecting the track/s that are most appropriate to you i.e. Architecture perhaps initially.

http://technet.microsoft.com/en-us/library/ms151198.aspx

You should eventually get to specific replication implementation scenario tutorial that is appropriate for your environment.

Related questions

How do I check SQL replication status via T-SQL?

I want to be able to check the status of a publication and subscription in SQL Server 2008 T-SQL. I want to be able to determine if its okay, when was the last successful, sync, etc.. Is this possible?

Read More
Pause SQL server replication temporarily

We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber. We have an activity to change the location of the replicated DB (subscriber) using de-attach and attach method. During this activity, …

Read More
Why SQL Server doesn't allow to remove a Distributor exactly after Configuration?

I Configured a distribution in SQL Server 2008 using both Wizard and T-SQL but after it when I want to remove it Using Wizard (right clicking on Replication and choosing 'Disable Publishing and Distribution...') or executing following command with and …

Read More