Friday, February 10, 2012

Bit Confused over Master SQL Server

Hi,
I'm developing a bit of a server farm so I thought I would
bite the bullet and set myself up a 'Master' server. This
would automatically send updates, jobs to the other
servers.
I think I may have my facts right that there is such a
thing but was wondering if there was, and of there was is
a way can anyone provide me with some good background
material.
TIAMaria,
there are details in BOL under "master server". The
details are more on the implementation side, but it is
not really difficult technology. Once you've set up your
master and target servers (MSX, TSX) please post back if
you have any questions.
Here are a couple of articles I found Googling:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_automate_7ir2.asp
http://www.winnetmag.com/SQLServer/Article/ArticleID/23982
/23982.html
Rgds,
Paul Ibison (SQL Server MVP)
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment